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?
While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful. I tested several solutions and share the results in this article as well as t…
Workbook link problems after copying tabs to a new workbook?
David Miller (dlmille)
Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.
Rather than update each graph to point to a different set within a static set of data, t…