Too many different cell formats error message.....

Rickster8

New Member
Joined
May 16, 2013
Messages
2
Hello ALL:

I am new to this board.

I have a file that is like 15 tabs long. It will not let me do any kind of formatting to it.

The message I keep getting is, 'too many different cell formats'. VERY ANNOYING!!!!!! :mad:

Just doing simple things like move/copy sheets and I get this error. Sometimes I can't even click on one individual cell and make it bold.... ARE U KIDDING ME?????

I even tried to delete all the formatting in the entire file and still no dice.

Any suggestions?

Thanks for your help,

Rickster8
 

alfranco17

Board Regular
Joined
Apr 14, 2013
Messages
190
I'd create a new workbook with 15 tabs, then copy each tab from the original and paste values with no formatting in the new one, tab by tab. That might help.
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,721
Office Version
2010
Platform
Windows
Got a lot of charts?
 

Rickster8

New Member
Joined
May 16, 2013
Messages
2
No there's actually no charts, but there are text boxes in every tab..... One of the people from the IT dept helped me out by running a scan on the file and it somehow cleared the source formatting and now I can format cells again....

She found a site that offered an xlstyletool and she ran this tool thru the file and somehow, someway, it worked....

Here's the link....

http://sergeig888.wordpress.com/2011/03/21/net4-0-version-of-the-xlstylestool-is-now-available/</SPAN></SPAN>

Cheers,

Rickster8
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,721
Office Version
2010
Platform
Windows
Glad you got it sorted.
 

Forum statistics

Threads
1,085,149
Messages
5,381,992
Members
401,764
Latest member
pzippel

Some videos you may like

This Week's Hot Topics

Top