Situatie
Microsoft Excel has a feature called Link Sheet that you can use to link the data on your one workbook to another worksheet. These links automatically update when you change something on the linked workbook.
Solutie
Pasi de urmat
- Open the Excel sheet
- There, go to the “Data” settings on the menu bar
- There, click “Edit links” to open that settings.
On the Edit Links prompt, tap “Startup Prompt…” to view the startup prompt. Next, you have to set the When this workbook is opened, Excel can ask whether or not to update links to other workbook setting, you have to select the “Don’t display the alert and update links“.
Finally, tap “OK” to save this choice.
You can find all the links here. So, select the link and tap “Open Source” to open the link source on your system.
Next, select the link and tap “Break Link” to break the link to the original source.
A warning message with the following message will appear –
Breaking links permanently converts formulae and external references to their existing values.
You can click “Break Links” to break the links.
This way, you can break the links. There wouldn’t be any error messages or banners in Excel. These fixes should have solved your problem for sure.
Leave A Comment?