Clearing the Excel Cache (Mac)
The Mac version of Clearing the Excel Cache (Windows). Same idea: when the Amalgam plugin misbehaves in Excel, deleting Excel’s add-in cache forces it to fetch a fresh copy of the plugin and often fixes problems nobody can otherwise explain.
When to Clear the Cache
Section titled “When to Clear the Cache”If the Amalgam sidebar will not load, shows an old version, or behaves strangely after an update, clear the cache before anything else. It removes only the add-in’s local files. Your workbooks and your Amalgam account are untouched.
How to Clear the Cache
Section titled “How to Clear the Cache”- Quit Excel completely (Excel > Quit Excel, not just the window).
- In Finder, choose Go > Go to Folder and paste this path:
~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/Office/16.0/Wef/
- Delete everything inside the Wef folder.
- Open Excel again and open the Amalgam plugin from the Home ribbon. If it is missing, add it again from Add-ins as described in How Do I Install the Excel Plugin?.
If the Wef folder does not exist, Excel has no cache to clear and the problem is elsewhere. Email support@amalgam.me with what you see.