Written by Allen Wyatt (last updated June 7, 2025)
This tip applies to Excel Excel in Microsoft 365
When Simon opens Excel, the program asks what he wants to open. It displays three tabs (Recent, Favorites, and Shared with Me). The problem is that Simon doesn't always get the full list of favorites on the Favorites tab; he usually just gets a couple. When that occurs, then he also doesn't get all the recently opened workbooks listed on the Recent tab. Simon cannot see a pattern in how or when this occurs, and it is very annoying to him.
I'm going to assume that Simon is using Microsoft 365 because that is the version in which this behavior makes the most sense. Excel and all Office apps are tied to the cloud in Microsoft 365, meaning that information regarding your installation is stored in Microsoft's servers. If your installation of Microsoft 365 cannot access those servers, even intermittently, then you can have strange things occur.
What might cause the lack of access? Obviously, an unstable internet connection could do it, as could a flakey connection through servers between your system and Microsoft. This could be the result of latency issues somewhere in the connection chain, or perhaps latency issues introduced on your computer because of background tasks bogging down the system.
If you store files in OneDrive or on some other virtual drive, such as Dropbox, then the problem can be exacerbated. Excel may know which recents or favorites it should display, but if it cannot reach those files in the virtual drive, then it won't display them because it believes they are no longer available.
If you don't think the issue is related to your internet connection or background tasks on your system, you might try completely signing out of Microsoft 365, restarting your system, and signing back in. That may refresh the data necessary for your Microsoft 365 account and help make things run smoother.
If that still doesn't help, consider clearing the file cache used by Excel. Navigate to the following folder:
C:\Users\username\AppData\Local\Microsoft\Office\16.0\OfficeFileCache
In this path, the "username" should be replaced with the name of your user account. Anything in the folder can be deleted. You should also realize that the cache is used by other programs in the Office suite, as well. Anything you delete from the folder will be automatically rebuilt the next time you start Excel (or other Office app).
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (11489) applies to Microsoft Excel Excel in Microsoft 365.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. Check out Mastering VBA for Microsoft Office 365 today!
If you work with multiple workbooks at the same time, you might wonder how to tie them together so they open and close at ...
Discover MoreWhile password protecting a workbook does provide some security for the contents in the workbook, if you have several ...
Discover MoreWhen working with copies of workbooks--particularly copies derived from a common ancestor workbook--you may be interested ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2025-06-09 17:29:14
J. Woolley
Using VBA, Excel's list of recent files is in the following collection:
Application.RecentFiles
Each item in that collection is a RecentFile object. A malicious macro could randomly delete items from the collection using a statement like this
Application.RecentFiles.Item(i).Delete
Such a macro might run each time a workbook is opened.
The following statement is supposed to add the active workbook to the "Favorites" folder:
ActiveWorkbook.AddToFavorites
I tried it, but it doesn't seem to do anything (Windows 11, Excel 365).
I don't know how to access Excel's list of favorites using VBA.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments