Worksheet links

  • Thread starter Thread starter Zacdent
  • Start date Start date
Z

Zacdent

I have a common column fro all my worksheest. Ihave set
up a link but the cells in the column whcih have no data
(but obviously formula present) are being produced in the
donor worksheets resulting in enteries in all rows and
unmanagaeable file size. Any suggesetions ?
 
Hi
what kind of link have you inerserted (something like ='sheet1'!A1).
Not sure for how many rows/columns you have created this link but if
you can reduce this only to the used range of sheet 1 this should
shrink your file.

So you may provide some more details what you have done and which
filesize your currently have, how many rows/columns you use
 
Exactly as you described. Rows are approx 100 but will
increase with time. 10 sheets with the common columns

Regards
 
Back
Top