|
Urgent
I am having a problem saving a file because it has too many conditional and
cell formats. Is there anyway to solve this problem? |
Reduce the number of cell formats.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Urgent" wrote in message ... I am having a problem saving a file because it has too many conditional and cell formats. Is there anyway to solve this problem? |
It is possible, by using the Macro Recorder, to record the actions that
applied the formats to your cells. Once this is done you can run the macro to re-paint the formats anytime you want. Before attempting to save the file, first clear all the formats in all the cells. When the file is re-loaded, execute the macro to re-paint the formats. -- Gary''s Student "Chip Pearson" wrote: Reduce the number of cell formats. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Urgent" wrote in message ... I am having a problem saving a file because it has too many conditional and cell formats. Is there anyway to solve this problem? |
You receive a "Too many different cell formats" error message in Excel http://support.microsoft.com/default...5BLN%5D;213904 Deleting Unused Formats code from Leo Heuser can be found in David Hager’s EEE007, about 1/2 way down the page. Look for DeleteUnusedCustomNumberFormats [also see updated version 2001-05-06] http://www.j-walk.com/ss/excel/eee/eee007.txt http://groups.google.com/groups?thre...%40tkmsftngp02 --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Chip Pearson" wrote in message ... Reduce the number of cell formats. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Urgent" wrote in message ... I am having a problem saving a file because it has too many conditional and cell formats. Is there anyway to solve this problem? |
| All times are GMT +1. The time now is 03:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com