In case, the user Excel workbook has a link with the data of another workbook and when you try to open your Excel workbook then this shows you the error “Excel we can’t update some of the links error”. Hence, in this blog you will read the solution of this excel error. For assistance, just contact Microsoft Support team via www.office.com/setup.
Method to Fix Excel Error “We Can’t Update Some of the Links in Your Workbook”:
1: Unlock Protected Excel Worksheet:
In case, the users have the password of their protected Excel sheet, then they can remove protection in few seconds. To unlock your protected sheet, first you should right-click on the Sheet tab. Then from the context menu, you should choose the Unprotect Sheet option. After this, you should go to the Review tab on your Excel application menu bar. Here from the Changes group, you should click on the option Unprotect Sheet. Now from the Home tab, just under the Cells group, you should click on the Format option. After this from the drop-down menu, you should choose the Unprotect Sheet.
If in case, your Excel worksheet is password-protected then it will ask you to enter the correct password. Here, you just type the password and hit the OK button. But if your worksheet was not locked, then you should click on the Unprotect Sheet option this will unlock the protected sheet.
2: Fix Excel Break Links:
It is suggested that you must keep a backup copy of your Excel workbook before begin this procedure. For this, you have to open your Excel workbook which shows you the error “we can’t update some of the links in your workbook”. Then, you have to go to the Data tab and just tap on the Edit Links option. At this point, you will view the Edit Links command displays unavailable if in case, the Excel workbook doesn’t have any links. Then in the Source file box, you should select the broken link which you want to fix. Now, you should click on the Change Source. Here, you should search the destination of a file which has the linked data. At this point, you should choose the new source file and then click on the Change Source. At last, click on the Close button.
3: Remove Excel Break Links:
For this, first you should open your excel workbook which shows the Excel edit links not working error. Then, you should go to the Data tab, and just click on the Edit Links. If in case, your workbook doesn’t have any links then you will see the Edit Links command will be inactive. But if the Edit Links command is active, then you should go to the Source file. Now from this box, you should choose the broken links that you want to delete. After the selection, you should click on the Break Link. At last, you should press on the Close button.
4: Disable Excel Update Links Error Message:
In the Excel workbook, you can get rid of this Excel update link error message by two ways:
Disable Update Links Message by using Excel Options:
First, you should go to the File tab of your Excel workbook and then click on the Options button. Now the Excel Options dialog box will open and from this, you should click on the Advanced option which is there in the left side. At this point, you should uncheck the option Ask to update automatic links which is there in the General option. Then, you have to click on the OK option to close the opened dialog box. Now, if you open this workbook, then the links were automatic gets updated. At this time, you will not receive any error messages.
Disable Update Links Message With Edit Links Feature: Office.com/setup
First, you should click on the Data and then you have to click on the Edit Links option. Now in the Edit Links dialog box, you should click on the Startup Prompt option which is at the bottom of the screen. Then in the opened Startup Prompt dialog box, you should select either Don’t display the alert and update links or Don’t display the alert and don’t update automatic links option according to your requirement. At last, click on the OK option and then close the opened dialog box. Now, when you open the workbook, you will not receive any update link message.
The above method will help you to fix Excel Error “We can’t Update Some of the Links in your workbook”. If the user want any support, then contact the expert of MS Office via www.office.com/setup.