Editing Links

agerrard

Active Member
Joined
Apr 4, 2005
Messages
406
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

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

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,176,629
Messages
5,904,128
Members
435,074
Latest member
McKay_S

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