Links Causing File Size Jump

[New2Macros]

It seems that when I paste links the file size jumps a lot.

The sheets are laid out like this - all the sheets have "lookup" formulas
which reference a master sheet. There are no macros or anything unusual.

I wanted to create an easy print sheet which references all of the other
sheets (except the master sheet). So I created a sheet, copied the format of
the others and pasted a link to them. The file size jumps immediately.

All I need is a print sheet, which makes it easy to print 25 other sheets at
once.

Any ideas?

 

[Gord Dibben]

Using CTRL + Click or SHIFT + Click, select All sheets except "Master" and
Print>Active Sheet(s)

You don't need the single sheet linking to all the others.


Gord Dibben MS Excel MVP

 

[New2Macros]

Thanks! I should have known that - I think that is what was causing our file
size trouble earlier along with the code problem.

 

[Gord Dibben]

Maybe partly..

I was able to create the file size jump in a new blank workbook with the
code.

As Dave said twice...........don't use that hiding rows code.


Gord