How to copy sheets and linked reports and dashboard without referencing original sheet
Is there an easy way to copy the data sheet for one project, together with the linked reports and dashboard, into another folder without referecing the original data sheet? The copied reports and dashboard need to reference the new copied data sheet. At the moment when I copy the the reports and dashboard, they are still taking data from the original data sheet rather than the copied data sheet.
Best Answer
-
Save everything into a folder and then make a copy of the folder.
Answers
-
Save everything into a folder and then make a copy of the folder.
-
Thanks Paul. Why didn't I think of that?
-
If you want to copy a report but have it run off the new workbook. Copy the report to the new workbook (using Save as), then in the toolbar select sheet and change this to the new sheet you want it to run off.
