inflating file size

Good afternoon all,

Hopefully someone will be able to help me out.

My excel sheet size has gotten out of control, i have been trolling the net and other forums looking for an answer... i gave up and decided to go with what works posting here.

so here is the deal i have a macro file (xlsm) that on the first of the month was 2mb+/-, today its over 5mb it is running VERY slowly and occasionally even crashing. i have deleted all the excess rows and columns, my sheet contains one sheet with about 2000 lines of data (including vlookups) and about 15-20 other sheets with minimal information and a few vlookups. all the files are interconnected to copy pasting to a new file is not really an option. in addition i read in another forum about disabling muti-threaded calculations, i did that as well and it did not help with the speed at all

Is there any other way to shrink the size and to get the speed fast again ?

ANY help would be much appreciated!!!!!

I wish i could but the information is classified...

I also just tired excelfilecleaner didnt help me either....

Originally Posted by popipipo

Then unfortunately I can not help you

Thanks for your help anyways

Hi
Try looking at the following link:
http://windowssecrets.com/forums/sho...cel-2000-SP1a)
Good luck.
Tony

Originally Posted by ARGK

Hi
Try looking at the following link:
http://windowssecrets.com/forums/sho...cel-2000-SP1a)
Good luck.
Tony

Thanks tony,

how do i make sure that Tools/Track Changes is not turned on ?

Hi
Click on thye Review Tab.
Towards the right hand side of the Ribbon click on Track Changes.
Click on Highlight Changes.
Untick the top box so it is blank.
Click on OK.
Save the document.
Hope this helps.
Good luck.
Tony