ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Link or Calculate? (https://www.excelbanter.com/excel-discussion-misc-queries/136863-link-calculate.html)

Graham Y

Link or Calculate?
 
I have 4 large worksheets (A1:GF521) that I link to a summary sheet, in
another workbook.
About 2/3 of the cells in the range C3:AG521 have data the rest of that
range have formulae as does about half the remaining area (AH1:GF521)
Is it better to:
link every single cell.
Fiddle about and link cells with contents only
link just the data cells and recalculate the formulae
Or some other technique (I want live links, otherwise I'd copy the sheets
via VBA)


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com