Symptom
In certain situation the user may need to manually clear the MS Office cache.
Environment
SAP Analytics Cloud, add-in for Microsoft Office
Resolution
For Microsoft Windows
Method 1: Delete the Cache Folder Directly
- Close all MS Office applications, including MS Outlook. Make sure no MS Office applications are running in the background as the cache clearing operations will fail in this case.
- Press Windows + R and type:
%LOCALAPPDATA%\Microsoft\Office\16.0\Wef - Press Enter to open the folder %LOCALAPPDATA%\Microsoft\Office\16.0\Wef
- Delete all files in this folder.
- Restart Excel.
Method 2: Using Command Prompt (Admin)
- Open Command Prompt as Administrator
- Run:
del %LOCALAPPDATA%\Microsoft\Office\16.0\Wef\*.*
Method 3: For Outlook Specifically
- Cache location:
%LOCALAPPDATA%\Microsoft\Outlook\Temporary Internet Files\Content.Outlook
For Mac OS
Method 1: Delete Cache Folder
- Quit all Office applications
- Open Finder → Go (menu) → Go to Folder
- Enter:
(Replace "Excel" with Word, Outlook, etc.)~/Library/Containers/com.microsoft.Excel/Data/Library/Caches - Delete cache files
- Restart Office
Method 2: Universal Path
~/Library/Containers/com.microsoft.[AppName]/Data/Library/Caches
For MS Office 365 Web
- Open browser Developer Tools (F12)
- Go to Storage or Application tab
- Clear Cookies and Local Storage
- Refresh the page
Please note that after clearing the cache, the following steps may be required:
- Restarting the MS Office applications
- Re-addingg any custom add-ins if needed
- Signing in again to Microsoft 365
Keywords
KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , How To
Product
SAP Analytics Cloud, add-in for Microsoft Office 1.0
SAP Knowledge Base Article - Public