CODEWITHSUNDEEP
excelvba
user15169505
user15169505

Reputation:

we can't update some of the links in your workbook

When i open the workbook this below window is pop up and said we cannot update some link i go to option advance and changed the setting ask to update automatic links.

But when i sent the workbook to my senior then same message is pop-up. I felt that the setting i made just for my system.

I am trying to find out the solution so that this message should not pop-up to anyone to whom i sent the workbook.

Your help will be truly appreciated.

enter image description here

Upvotes: 0

Views: 814

Answers (1)

Toddleson
Toddleson

Reputation: 4457

In the Workbook code module, paste in the following Sub, which sets the update links property for the workbook:

Sub UpdateLinksNever()
    ThisWorkbook.UpdateLinks = xlUpdateLinksNever
End Sub

Run this sub once and then save your workbook. After you've saved the workbook, you can remove this sub.

To Find the Workbook Code Module, go to your excel workbook, press Alt+F11. Press Ctrl+R. Press "T". Press "Enter".

You could also put it into any of the modules in the workbook, but this is the best spot for it.

Upvotes: 2

Related Questions