How to clear the cache linked to the OData Feeds in Excel
Jump to navigation
Jump to search
Overview
Excel caches multiple information regarding the OData feeds into a global caches.
It is worth nothing that some information in the cache is shared across multiple excel workbooks. For instance, the schema of specific OData Feeds.
In some situations, this cache must be cleared. This is particularly important when changes are made to the schema (e.g. when new fields are added to specific endpoints).
How clear the cache linked to the OData Feeds in Excel
To cllear the cache linked to the OData Feeds in Excel, follow these steps.
- In Excel with the workbook open, click on the Get Data button in the Data Tab and select Query Options.
- Select 'Data Load under Global.
- Scroll towards the bottom until you find the Clear Cache buttons.
- Click them to clear the cache.