ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   error message that says "too many different formats" Fix? (https://www.excelbanter.com/excel-worksheet-functions/225470-error-message-says-too-many-different-formats-fix.html)

jojo

error message that says "too many different formats" Fix?
 
I am operating a huge Excel workbook with lots of internal links and lots of
formatting. But now I am getting error messages that say wtte " too many
different formats" and now it won't let me format much. It hasn't completely
shut down my formatting abilities but it has limited them severely. I have no
external links to this workbook. What can I do to re-attain my ability to
format stuff? I cannot take a whole lot more worksheets out of the workbook.
It has to be fixed I am running out of work arounds and it is getting hard to
deal with now.

Mike H

error message that says "too many different formats" Fix?
 
Hi,

There may not be a workaround other than delete some formats because Excel
has limits for these and many other things. Have a look here

http://support.microsoft.com/kb/213904

and here

http://office.microsoft.com/en-us/ex...992911033.aspx

Mike

"JoJo" wrote:

I am operating a huge Excel workbook with lots of internal links and lots of
formatting. But now I am getting error messages that say wtte " too many
different formats" and now it won't let me format much. It hasn't completely
shut down my formatting abilities but it has limited them severely. I have no
external links to this workbook. What can I do to re-attain my ability to
format stuff? I cannot take a whole lot more worksheets out of the workbook.
It has to be fixed I am running out of work arounds and it is getting hard to
deal with now.



All times are GMT +1. The time now is 10:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com