Links Causing File Size Jump


N

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?
 
Ad

Advertisements

G

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
 
N

New2Macros

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

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top