Replacement Issue

Agamemnon

Board Regular
Joined
Sep 8, 2003
Messages
113
Hi,

I have a worksheet with about 1600 links to another workbook:
Now I've tried to replace the link af that workbook to another workbook by using the replace commando (CRTL+H) and pushed the replace all button.

The problem now is that I accidently typed a wrong name for the new workbook and excel is asking me 1600 times which file I want to link with.
Is there a way to stop this. I think I've tried already of keyboard combinations but none were succesful.

Thx for helping me out.
Aga
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Domski

Well-known Member
Joined
Jan 18, 2005
Messages
7,292
Hi,

Not sure if you can stop it in Excel.

Assuming you'd saved it before doing the replace I'd probably kill Excel with the task manager and start again.

Dom
 

jc113883

Board Regular
Joined
May 29, 2006
Messages
165
Open a blank workbook and run a macro with the following line:

application.dispalyalerts = false

Then open your workbook and see if that works. My guess is that it might not! Either way, you'll have to run the macro again and set displayalerts to True once you're done.
 

Forum statistics

Threads
1,181,399
Messages
5,929,743
Members
436,687
Latest member
Glass of Gin

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