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?

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

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


Gord Dibben MS Excel MVP

On Tue, 26 Jan 2010 08:41:02 -0800, New2Macros
wrote:

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?

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" wrote:

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

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


Gord Dibben MS Excel MVP

On Tue, 26 Jan 2010 08:41:02 -0800, New2Macros
wrote:

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?

.

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

On Tue, 26 Jan 2010 11:57:02 -0800, New2Macros
wrote:

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" wrote:

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

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


Gord Dibben MS Excel MVP

On Tue, 26 Jan 2010 08:41:02 -0800, New2Macros
wrote:

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?

.