Urgent

U

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?
 
G

Gary''s Student

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.
 
Top