Size of worksheet
 

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

Size of worksheet
 

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.

Size of worksheet
 

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.

Size of worksheet
 

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