excel reference locked to original wookbook
Posted on 2012-08-21
I have a dashboard that is pulling in report data from 6 other sheets in the workbook, to create graphs (charts) and other reference information.
My problem is that I want to use the dashboard sheet as a template and be able to copy it into other excel files that contain the same layout (but different data). When I copy the sheet across to a new file all the formulas are still referencing the original workbook and not the new one I have pasted it in to, even though the tabs are named the same way. If I close the original workbook the formula has a file reference in it.
How can I copy the sheet across without excel automatically updating the formulas to reference the old file?