After then go to the Data tab, and hit the Edit Links option.Firstly, you need to open your Excel workbook which is showing the “Excel break links not working” or we can’t update some of the links in your workbook error.Keep a backup copy of your Excel workbook before starting up this procedure. So, in that case, just type the password and tap to the OK option.īut if your Excel worksheet was not locked with any password then tapping on the Unprotect Sheet option will unlock the protected sheet. If your Excel worksheet is password-protected then the Excel application will ask you to put the correct password. after than from the drop-down menu choose the Unprotect Sheet From the Home tab under the Cells group, tap the Format option.

Now from the Changesgroup, hit the option Unprotect Sheet. Go to the Review tab on your Excel application menu bar. Now from the context menu choose the Unprotect Sheet option. You can try any of the following methods to unlock your protected sheet: If you have the password of your protected Excel sheet, then the task of removing protection only takes a few seconds. This process will help to Break The Link To An External Reference In Excel.

Know complete steps to unlock password protected Excel worksheet. Mostly it is seen that users encounter “ Excel edit links error source not found” issue also when they had protected Excel worksheet. Method 1: Unlock Protected Excel Worksheet SOURCE: How To Remove “We Can’t Update Some Of The Links In Your Workbook” Error? I always try to link to the file on my local PC, but have noticed that the links always change to d./ – I assumed this was just something to do with working with OneDrive but don’t know if this is causing a problem? This month when I have done that I keep getting an error message ‘Cannot access XXXX.xlsx’. Each month I click edit links – change source – and then click on the new source file that I want to use for the current month. I have used this set up for months and have never had a problem. I have a destination workbook which contains links to various source documents.

Preview the repaired files and click Save File to save the files at desired location.

Select the corrupt Excel file (XLS, XLSX) & click Repair to initiate the repair process.

Download Excel File Repair Tool rated Excellent by Softpedia, Softonic & CNET.

Disable links in excel spreadsheet