How to copy sheets and linked reports and dashboard without referencing original sheet

safdar rashid

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.

Paul Newcome

Save everything into a folder and then make a copy of the folder.

Paul Newcome

Save everything into a folder and then make a copy of the folder.

safdar rashid

Thanks Paul. Why didn't I think of that?

Paul Newcome

Happy to help. 👍️

Kate Miller

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.