Latest Updates in Technology, Programming, Finance, Books, Useful Websites, Gadget Reviews & More

Excel: How to handle error message “This workbook contains one or more links that cannot be updated”?

There are two options to handle this error message.

1. If you are absolutely sure that the links are unnecessary and redundant, then you can simply remove them by following these steps.

a. Go to data tab in Excel ribbon

b. Click edit links






c. Select "Break link"


2. Option 2

If the link is necessary and if you don't want to break it, then you can choose to either "Update the Values" or "Change Source" and browse for the location of the source file.

Hope this helps.


Filed under: Tips & Tricks No Comments