Improve company productivity with a Business Account.Sign Up

x
?
Solved

Excel reaches 4000 different styles / formats

Posted on 2014-02-07
4
Medium Priority
?
209 Views
Last Modified: 2014-02-11
Greetings,
The way I understand this problems is that when Excel reaches 4000 different styles / formats (due to multiple users copping and pasting data into a workbook / previous versions of Excel, it breaks the given workbook. Is it possible to do a select all on this book to standardize the styles / formats without breaking things further? I did find a possible MS fix it, however don’t want to exacerbate the situation, if it’s even approved in our environment
Thanks in advance.

Ken
0
Comment
Question by:kennethjk
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
broro183 earned 2000 total points
ID: 39845052
hi Ken,

I recommend making a copy of your workbook & then trying the Remove Styles addin which is mentioned on one of the MS KB pages (# 213904). I have successfully used this free addin to remove excess formats that were being created through copying SAP extracts from one excel instance to another. My issue was different from your current one but I think it will work for you, based on others' comments in the links.

The above addin is discussed briefly on this blog.

To use the add-in, I would save the file somewhere on your computer, open excel, press [alt + t + i], then Browse, choose the addin file, make sure the check box next to it is ticked & press [ok]. Open the copy of your file & click the “Remove Styles” button on the Home tab.

hth
Rob
0
 

Author Closing Comment

by:kennethjk
ID: 39847637
Thank you so much

Ken
0
 
LVL 10

Expert Comment

by:broro183
ID: 39849424
hi Ken,

I'm pleased I was able to help :-)

Rob
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This tutorial is about creating a new Microsoft Online User Profile account along with how to transfer your files and settings. You may be faced with this situation if your existing user profile has become corrupted.
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question