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