View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DaveMoore DaveMoore is offline
external usenet poster
 
Posts: 32
Default I have a file that is 4mb. Cleared all formating...still big

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?