Keeping correct links when copying workbooks with formulae

kipstey

New Member
Joined
Sep 4, 2003
Messages
20
I want to create a template folder with various links as follows:

Datasheet.xls
Folder 1 - Detail1.xls and Summary1.xls
Folder 2 - Detail2.xls and Summary2.xls

- Summary1 contains links to Detail1
- Summary2 contains links to Detail2
- Detail1 contains links to Datasheet
- Detail2 contains links to Datasheet

I have set up this folder, but I would like to be able to just copy and paste this folder and have the links in the new folder reading within the new folder - but instead the formulae read from the original files.

The only way I can find to do this is to open all 5 files at the same time and save them in turn to the folder. However, this is not very efficient for the number of times that I have to do this so I'm hoping that you guys know a better way :)

I was also wondering if it is possible to rename 2 linked files while closed (e.g. in Explorer) and have them remain linked to each other (under the new name) rather than Excel searching for the old named file?

Thanks in advance for any help!
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

tactps

Well-known Member
Joined
Jan 20, 2004
Messages
3,460
I would copy the files across, open the one that is liked to the others and then use "Links" from the edit menu to change them. However, it will still work quicker if you have all files open.

This will be quicker then saving all files.
 

Forum statistics

Threads
1,148,530
Messages
5,747,234
Members
424,070
Latest member
smanni3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top