There’s no way to tell because there are no error messages or other clues … Grrr. Either a connection problem to Microsoft’s servers or a failure in Excel. Here’s some tricks from real-world experience that should restore Stock and Geography data types. The ribbon section and entire feature stops working without explanation or information, let alone help. When Excel can’t connect to Linked Data Types for whatever reason, there’s no error message or explanation. Normally if a feature isn’t available, that button or option is just greyed out, not removed completely. That’s very different from the standard Office behavior. The Queries and Sort ribbon sections get ‘pushed aside’ and Data Types appear between them. On a slow computer you might even see Data Types appear on the Data ribbon after startup. Excel doesn’t try to connect with the data servers after the failure at startup. 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.
EXCEL FOR MAC PRICE 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.
Thanks for joining us! You'll get a welcome message in a few moments.
0 kommentar(er)
