

Even worksheets already setup with Stock or Geo links show errors instead of updating.

If that initial data connection fails, Linked Data Types won’t work at all.

If it can’t get a connection, then Excel won’t display anything on the Data ribbon. When Excel 365 starts, it checks with Microsoft’s servers to see what Linked Data Types are available. It’s a strange problem caused by an equally strange design decision by Microsoft. We’ve had several reports from readers who start Excel 365 and find that their Stock and Geography linked data worksheets won’t work. The Data ribbon is missing the entire ‘Data Types’ section.
RESTORE WINDOWS TAB ON EXCEL FOR MAC HOW TO
When the Stock and Geography data types disappear from the Data ribbon in Excel here’s how to fix and restore Linked Data Types.
