View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DILipandey[_2_] DILipandey[_2_] is offline
external usenet poster
 
Posts: 17
Default I have a file that is 4mb. Cleared all formating...still big

Hi JDH,

Try below options:-
1) Delete the columns to the right and rows after last row of the data.
2) Check if there are some objects used in the excel file.
3) Check if there are some sheets XLveryhidden.
4) Check for the specia fonts /formatting / formulation from external links.

At the end, copy your data to some other excel file and save that as yours
new file. :)

If possible, send that file to me and I can give a try.

Best of luck.
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


+91 9810929744
New Delhi, India


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