MrExcel Publishing
Your One Stop for Excel Tips & Solutions

cell formatting

Posted by brian lin on January 23, 2001 2:26 PM

I am trying to copy a sheet from one file to another file. The destination file is quite large and has many different cell formats associated with it. Upon trying to copy the sheet, I am receiving an error indicating there are too many cell formats and I get an "out of memory" error. Thus, the copy is unsuccessful.

I believe many of the existing formats contained within the destination file are probably not used within the spreadsheet.

Does anyone know how to audit the cell formats to determine whether or not they are being used within the spreadsheet? I would like to delete (preferably using a group delete function)all of the formats not currently being used

Posted by Dave Hawley on January 23, 2001 9:21 PM

Hi Brian

Highlight all cells on the Worksheet and push F5 then Special>Blanks. click OK. Now go to Edit>Clear>All. Do the same for each Worksheet.

Hope this helps

OzGrid Business Applications

Posted by brian Lin on January 24, 2001 11:30 AM

It does not work. It came up with same error message.

Posted by Dave Hawley on January 24, 2001 9:23 PM

How many Workbooks did you have open when you tried and how BIG are they ?


OzGrid Business Applications