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)