Editing Links

agerrard

Active Member
Joined
Apr 4, 2005
Messages
405
Hi all,

Im using Excel 2003. I have two files one of which links to the other. The file im trying to update is 4MB and the file that im sourcing the link to is 15MB.

I've had to re-create the links as i've copied the file into another location. So when i go edit/links/change source Excel starts working, but it takes a really long time to re-create the links. In fact after a while it stops responding and i have to Ctrl/alt/delete to start over.

Im just wondering if anyone has any clues as to why Excel cant re-create the links and why i have to ctrl/alt/delete all the time. Is there something im missing or different that i can do to see how the links are being updated?

Cheers,
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi

I don't know if you already do it like this, but make sure you have both workbooks open when you change the links - I find this speeds things up no end (and in some cases is the only way I seem to be able to update the links).

Best regards

Richard
 

Forum statistics

Threads
1,141,630
Messages
5,707,520
Members
421,512
Latest member
jc364698

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