Excel 2007 best practices when linking to an external workbook
Posted on 2011-09-15
I have a workbook in Excel 2007 in which 8 sheets have up to 1800 formulas linking to an external workbook. Since each sheet has the same formulas in the same cells, I could easily set it up so that one sheet links to the external workbook and let the other 7 sheets link to that sheet.
Would that somehow be more of a "best practices" way to do it? Or does it matter either way?