Changing Links

Burnleyfc

New Member
Joined
Aug 29, 2002
Messages
10
I have a number of individual spreadsheets which report on various contracts and a spreadsheet that picks up information from all the individual sheets to provide a cumulative report.

I therefore have a master copy for each of the sheets which are saved as the new week commencing date when created.

However when creating the new cumulative sheet the links will obviously refer to the previous weeks spreadsheets. Is there a way to change all the links when creating the new spreadsheet?

Help.....?
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

XL-Dennis

Well-known Member
Joined
Jul 27, 2002
Messages
1,920
On 2002-08-30 06:59, Burnleyfc wrote:
I have a number of individual spreadsheets which report on various contracts and a spreadsheet that picks up information from all the individual sheets to provide a cumulative report.

I therefore have a master copy for each of the sheets which are saved as the new week commencing date when created.

However when creating the new cumulative sheet the links will obviously refer to the previous weeks spreadsheets. Is there a way to change all the links when creating the new spreadsheet?

Help.....?

It´s not an easy task to achieve however one manual solution is to
Use Edit | Links... and change the reference from "Book1" into "Book2".

This will delete the links, leaving the names referencing ranges in "Book2".

Or, perhaps a better way is to use the command Edit | Replace... :)

Kind regards,
Dennis
 

Forum statistics

Threads
1,144,358
Messages
5,723,889
Members
422,524
Latest member
wirkkarn

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