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

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.

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.

--


Jakob

"Chris Rogers" skrev i melding
ups.com...
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.

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

Lynda wrote:

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

--

Dave Peterson