Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home»Software»How to Clear Cache in Microsoft Excel

How to Clear Cache in Microsoft Excel

Grishma GhaleBy Grishma GhaleMarch 23, 2022
clear-cache-in-excel

Microsoft creates a copy of every file we create either on Excel or any other program. All these backup files reside in the cache folder, and you can use them to recover your files. But, although cache files are helpful, they can get corrupted and cause Microsoft to crash. 

So, it’s best if we can clear cache regularly to keep Microsoft running smoothly. In this article, let’s dive into how we can clear cache in Excel. 

Table of Contents

  • How to Clear Cache in Excel on Windows
    • Disable the Recent Documents List 
    • Using the Microsoft Upload Center 
    • Try Windows Disk Cleanup  
    • Clear Pivot Table Cache 
  • How to Clear Cache in Excel on Mac
  • How to Clear Microsoft Office Cache on Windows
  • How to Clear Microsoft Office Cache on Mac
  • How to Fix the ‘Microsoft Office Document Cache Encountered a Problem’ Error

How to Clear Cache in Excel on Windows

You can find the Excel cache location in your C drive, specifically the AppData folder. This is the default folder where MS Excel saves backup copies of your files. Nevertheless, there are a few easy ways you can clear cache in Excel. 

Disable the Recent Documents List 

One of the first ways you can try to clear cache in Excel is by clearing the recent documents list. Here are the steps you need to take to turn it off: 

  1. Open Excel and click on File in the top-left corner. 
  2. In the menu page, click on Options that’s on the left panel. 
  3. Click on the Advanced tab. 
  4. Scroll down to view the Display section. In the option that says Show this number of Recent Workbooks, select the number zero. 
    show-this-number-of-recent-workbooks
  5. Click on OK. 

Using the Microsoft Upload Center 

You automatically get the Microsoft Upload Center when you get Office programs. So, you can use it to manually clear Excel cache files. You can open the Upload center by simply typing its name in the search bar. Then, you can follow these steps: 

  1. Click on Settings.
    settings-upload-center
  2. From the Settings, check the box that says Delete files from the Office Document Cache when they are closed.  
  3. Click on Delete Cached files. 
    delete-cached-files
  4. The program will show you a pop-up window asking you to confirm. 
  5. Click on Delete Cached information. 

Try Windows Disk Cleanup  

You can use the Windows Disk Cleanup to eliminate any temporary files and clear the cache of programs, like Excel. Here’s how you can use it: 

  1. Open Windows Disk Cleanup by typing its name in the search bar. 
  2. Choose the drive where you can find MS Office. Click OK.  
  3. Once the process of analyzing files is over, check the Files to delete option. 
  4. Check the box that says Temporary files and click OK. 
    clean-temporary-internet-files

Clear Pivot Table Cache 

You can also clear the Excel cache by clearing pivot table cache. Here’s the way you can perform this action using the PivotTable Options.

  1. Hit right-click on one cell. You can now view the context menu. 
  2. Click on the pivot table “Options…”
  3. Click on the Data tab. Select the value of “Number of items to retain per field” to “None.” 
    number-of-items-to-retain-per-field
  4. Click on OK.  
  5. Now, right-click on the pivot table cell and click on Refresh. 

How to Clear Cache in Excel on Mac

Since most of the processes are similar to Windows, you can refer to all the solutions above to perform on Mac. However, there is one exclusive method you can try on Mac to eliminate Excel cache: 

  1. Close all of the Office programs. 
  2. Launch Finder and go to the Users > (Your device name) > Library > Containers > com.Microsoft.OsfWebHost > Data. You can delete all files within that folder. 

If you have trouble finding the exact folder, you can also look for folders with other names via Terminal.

  1. Search and go to Library > Containers > com.microsoft.excel > Data > Library > Caches.
  2. Alternatively, you can also go to com.microsoft.Office365ServiceV2 > Data > Caches > com.microsoft.Office365ServiceV2. 

How to Clear Microsoft Office Cache on Windows

Besides Excel, you can also clear the complete cache files of all other apps in Microsoft Office. Doing so will make sure all other apps perform well. You can find the Office Document Cache feature in the MS Office Upload Center. An easy way to clear the Office cache is by choosing an automatic setting. 

This method works especially for Office versions of 2108 or newer. Every time you reopen Office, your cache files will automatically disappear. 

  1. Open any Office program and click on File.
  2. Click on Options  
  3. Go to Trust Center > Trust Center Settings > Trusted Add-in Catalogs. 
    trust-center-settings
  4. Tick the box that says Next time Office starts, clear all previously-started web add-ins cache. 
    clear-web-add-ins
Note: This step is not compatible with Outlook.

How to Clear Microsoft Office Cache on Mac

You can use the personality menu of a task pane add-in to remove Office cache files on Mac: 

  1. Select the personality menu. 
  2. Click on Clear Web Cache. 
Note: You can only find the personality menu if you have macOS version 10.13.6 or newer.

How to Fix the ‘Microsoft Office Document Cache Encountered a Problem’ Error

As mentioned previously, your Office cache files can get corrupted at times. MS apps will not function properly when this happens, and your files can get stuck. You might even see the error ‘Microsoft Office Document Cache encountered a problem.’ Along with it, you’ll also get a link for repairing. But, clicking on it can lead to more errors. 

You can follow the steps above to delete Office cache files entirely to fix the said error. Other fixes you can try are performing a clean boot and restarting your PC. Here’s how you can perform a clean boot on your PC: 

  1. Type in System Configuration in the search bar. 
  2. Click on the Services tab. 
  3. Check all the boxes and click on Hide all Microsoft services. 
  4. Click on Disable all. 
    hide-all-microsft-services
  5. Click on the Startup tab and click on Open Task Manager.
  6. Select all programs and click on Disable.
    status-disabled
  7. You can now close the Task Manager. 
  8. Now, go back to the Startup tab of System Configuration and click OK. 
  9. Finally, restart your PC. 
how-to
Grishma Ghale
  • LinkedIn

As a veteran Apple user, Grishma Ghale is a fan of its products and loves to write about anything iOS/macOS. Besides that, she also writes about other platforms she enjoys, like Windows, Netflix and other productivity software. At TechNewsToday, she tests with multiple Apple or Windows devices and software to write about only the verified solutions for your ease. She has a total of 7 years of experience as a Content Writer/Editor and a Master's Degree in Literature under her belt. It was around 3 years ago that she ventured into learning and writing about Tech. It's because she believes it's almost a necessity, given our relationship with technology today. During leisurely hours, she indulges in afternoon tea while writing poems and short stories, journaling, and reading books. She’s also a coffee lover, a croissant connoisseur, and a singer - a self-proclaimed one of course. You can contact her at grishma@technewstoday.com

Related Posts

How to Disable NVIDIA Overlay

5 Ways to Disable NVIDIA Overlay

February 23, 2023
Notepad++-Plugins-Not-Installing

Notepad++ Plugins Not Installing? 5 Proven Ways to Fix It

February 20, 2023
MSI-Gaming-App-Not-Opening

MSI Gaming App Not Opening? 6 Ways to Fix it

February 17, 2023
MSI Afterburner Not Working

MSI Afterburner Not Working? Try These 7 Fixes

February 17, 2023
check mark in excel

How to Put Check Mark in Excel

January 20, 2023
how to find duplicate in google sheets

How to Find Duplicate in Google Sheets

January 16, 2023
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
Memory-Compression

What is Memory Compression in Windows? Should You Enable or Disable It

March 1, 2023
dism-vs-sfc-vs-chdsk

DISM, SFC, CHKDSK: What’s the Difference

February 28, 2023
bios-settings-for-gaming

Best BIOS Settings for Gaming

February 16, 2023
You may also like
how-to-clean-hp-printer-rollers

How to Clean HP Printer Rollers

March 3, 2023
keyboard input lag

9 Ways to Fix Keyboard Input Lag

March 3, 2023
keyboard key is stuck

How to Fix a Stuck Key on a Keyboard

March 3, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Our Team
  • Editorial Guidelines
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday, editor@technewstoday.com | Tech Central Pvt. Ltd.

Type above and press Enter to search. Press Esc to cancel.