Copy a set of sheet that have links

I have created a set of sheets that I will use to managed various parts of a Project. Between the sheets, I've linked a number of cells, pulling data from one sheet to another.

As I'm going to run this type of project many times, I need to copy this set and reuse them for another project.

I can copy the sheets, but the links are still referencing the original set.

Is there a way to copy the set and keep the links referring to the sheets in the copied set?

For example -

Set 1 has a Sheet called Project 1 Schedule. The dates from the schedule are linked to another sheet Project 1 Site Data.

Can I copy these sheets and keep the links from Copy of Project 1 Schedule to Copy of Project 1 Site Data?

I don't want to recreate the links every time I start an new Project.

Find more posts tagged with

Project Management

Cell linking

Comments

Travis

Hi Allan! Yes this is possible. Add all the sheets you want to copy to a folder or workspace on your Home tab. Then right click on the folder/workspace and select Save as New. By default, it will keep all the links relative to the newly created sheets.

P.Bushong

I have a workspace that needs to be updated from a workspace created with new data. When I remove the sheets from the workspace then re-add them from another workspace as save by new, then links do not get copied over. I have to go and manually update each one. Example I have a set of Folders in the new workspace with Sheets, dashboard etc, then I copy the entire folder set and save as new to Orig workspace, the links stay in the new workspace and not the orginal. However if I save as new the whole workspace then the links are good. It doesn't work on an existing workspace. Is there a way around this?