G
Greg
I've got a Master worksheet with 60,000+ rows and 150+ columns. From this
sheet, there are eight linked worksheets which divide up the display of this
Master sheet data. I've written a little formula so that zero values are not
displayed on the subsheets if there is a blank on the Master:
=IF(Master!A2<>0,Master!A2,"")
The formula works fine, but when I AutoFill this (A3, A4, etc.) all the way
down the 60,000+ rows and the generous number of columns, I'm increasing the
size of the Excel file by over 40MB for *each* subreport! Right now, there
are only a few sample records in the Master sheet, so obviously, the increase
in file size is due to the actual insertion of the formulas in the worksheets.
Is there any way to simply write a Macro to perform all these link
calculations without having to have a formula inserted into each cell? Maybe
it would also be 'smart' enough to simply not perform the link function if
there is no data in the Master, too!
I'm assuming that the substitution
of this macro would significantly decrease the file size.
Any help would be greatly appreciated, thanks.
Greg
sheet, there are eight linked worksheets which divide up the display of this
Master sheet data. I've written a little formula so that zero values are not
displayed on the subsheets if there is a blank on the Master:
=IF(Master!A2<>0,Master!A2,"")
The formula works fine, but when I AutoFill this (A3, A4, etc.) all the way
down the 60,000+ rows and the generous number of columns, I'm increasing the
size of the Excel file by over 40MB for *each* subreport! Right now, there
are only a few sample records in the Master sheet, so obviously, the increase
in file size is due to the actual insertion of the formulas in the worksheets.
Is there any way to simply write a Macro to perform all these link
calculations without having to have a formula inserted into each cell? Maybe
it would also be 'smart' enough to simply not perform the link function if
there is no data in the Master, too!
I'm assuming that the substitutionof this macro would significantly decrease the file size.
Any help would be greatly appreciated, thanks.
Greg