Hidden sheets, excessive use of formulas, formatting in non used cells, uncompressed images would be a good place to start.
I've found if you delete all the rows to the bottom of your used data and all the columns to the right, this often reduces sheet size, especially on older sheets that have had a lot of edits/insertions/deletions etc.
Is there anyway to see if two pivot tables are using the same data source. I know the data comes from the same table but how do i know for sure if they have created a seperate "cache" <-- is this correct.
Hi Guys, I discovered this Excel Diet searching elsewhere and was wondering how reliable it is? I have tried it on files of 35Mb which it has flattened to 300kb, it seems to have kept all the formulae that I wanted but I was just wondering whether anyone else had any experience good or bad? It seems quite the panacea for my purposes but is it too good to be true?
I also seem to have no problem running in 2007 but when I try in 2003 i am getting a syntax error and the macro won't run, I have changed nothing just am running from a colleagues pc which has not yet upgraded to 2003. Any idea anyone?