Size of worksheet

[Lynda]

Hi,

My worksheet has grown considerably in the last few weeks
and i was wondering which things take up the most space
on the spreadsheet, also has anyone got any tips on
getting the size down?

Thanks

Lynda

 

[Chris Rogers]

Pivot tables take up quite a bit of space.

I have a spreadsheet that was 48Mb...added 30 more pivot tables with
graphs and it's now at 575Mb.

 

[Jakob Austgulen]

It is smart to make one "big" pivot table, and Pivot nr.2 is made out of the
first one.
Then the file is not so big.

 

[Dave Peterson]

Debra Dalgleish has some techniques for resetting the last used cell (Does
ctrl-end go way past where you think it should be??).

http://www.contextures.com/xlfaqApp.html#Unused