I cannot link data between spreadsheets

Occasional Visitor

When I type the data in the spreadsheet cell and press Enter, this appears: External Data Connections have been disabled.

 

When I then click on Enable Content I get this error: Unable to get updated values from a linked workbook.

 

How to solve this situation?

2 Replies

@gansopro 

This Link describes the formula syntax and usage of the HYPERLINK function in Microsoft Excel.

HYPERLINK function

Excel for the web the HYPERLINK function is valid for web addresses (URLs) only. Link_location can be a text string enclosed in quotation marks or a reference to a cell that contains the link as a text string.

If the jump specified in link_location does not exist or cannot be navigated, an error appears when you click the cell.

Work with links in Excel

 

Hope this information could help you.

 

Wish you a nice day.

Nikolino

I know I don't know anything (Socrates)

 

 

@gansopro 

It looks like

- you have links on another workbook

- when you add data to cell, worksheet is recalculated

- "Enable Content" is default behaviour

- after enabled, Excel tries to get data from another workbook but can't find it

 

You may check Workbook links in Data section to check them