| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Urgent" use script to share the workbook | Excel Discussion (Misc queries) | |||
| Shared Workbook Problem, Urgent | Excel Discussion (Misc queries) | |||
| Urgent help! how to automatically resize all the charts? | Excel Worksheet Functions | |||
| Urgent Urgent Urgent!!! | Excel Discussion (Misc queries) | |||
| importing multiple text files URGENT!!! HELP | Excel Worksheet Functions | |||
Linear Mode
