Important rider.

After the unused row and column deletions you must SAVE the workbook.

I some earlier versions you had to Save, Close and re-open to effect change.


Gord Dibben MS Excel MVP


On Thu, 28 Jan 2010 09:14:49 -0800 (PST), DaveMoore
wrote:

I have found that deleting ALL columns to the right of my required
data and ALL rows below was effective in removing unwanted
formatting. Crude perhaps, but it works.
Just today I reduced a 4mb s/sheet to 275k.

Best o' luck


On 28 Jan, 16:47, JDH wrote:
I have a file that has cols a-p, rows 1-40. * Had a lot of colors and stuff
but I cleared all formatting and saved file. * Still 4mb. * Can't figure out
where the issue is. * Can anyone help?