How to fix if Microsoft Excel security warning: automatic update of links has been disabled via links option

Configurare noua (How To)

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 worksheet where you are seeing this banner.

Then, click on “File” and then, tap “Options“.

Options

This will open up the Excel Options page on your screen.

  • Here, head down to the “Advanced” pane.
  • You can find many options here. So, navigate to find the When calculating this worksheets section.
  • Now, uncheck the “Update links to other documents” option.
  • Then, tap “OK” to save this change.

Now, it is recommended that you close and relaunch Excel. Check if this removes the banner from Excel or not.

Tip solutie

Permanent

Voteaza

(1 din 1 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?