How to reduce .Xlsm file size

[rehman4me]

Hi everyone!

My file size is upto 29MB, although no data is entered yet. How can I reduce its size as there is no excessive programming or pictures in it.

 

[RoryA]

Welcome to the forum.

That's a pretty vague question. What is in the file currently? Also, if you select each sheet in turn and press Ctrl+End, does the selection jump to a cell well past the end of what should be the used range of the sheet?

 

[rehman4me]

Can I attach the file?

 

[RoryA]

No, not here. If you can upload it to a sharing site like Dropbox/Onedrive and post a link here, I will take a look.

 

[rehman4me]

Thanks Rory

Following is the link to the file in Dropbox. If prompted for password, Use nanser. if to unlock individual sheets use 123.

https://www.dropbox.com/s/6wwwb27jvrtrm5g/Salarzai Petroleum.xlsm?dl=0

 

[Fluff]

Have a look at the meter reading sheet.
You have data going down to the very last row on the sheet, ie row 1048576