How to Restore Missing SharePoint Sites in the Office Save Dialog

When working on a team project, saving your documents directly to the cloud is essential for collaboration. If you open Microsoft Word or Excel, click the Save As option, and find that your company's cloud locations are completely gone, you need to know restoring Missing SharePoint Sites in the Office Save Dialog. This frustrating issue typically happens because the authentication token between your desktop application and Microsoft 365 services has expired, the Office cache is corrupted, or the specific site is no longer registered as a prioritized location by the Microsoft Graph API. This troubleshooting guide provides the exact steps to diagnose the cause and force your Office applications to recognize your SharePoint directories again.

Reconnecting Office to Microsoft 365 Cloud Services

The most common reason SharePoint sites vanish from the save screen is a stale connection in your desktop software. If your credentials expire in the background, Office stops retrieving the list of sites from the server but may not display an overt error message. To address restoring Missing SharePoint Sites in the Office Save Dialog, your first diagnostic check should be refreshing your connected storage services.

Follow these steps to reset the cloud connection:

• Open any desktop application like Microsoft Word or Excel.
• Click on the File tab in the upper-left corner, then select Account from the bottom of the left-hand menu.
• Look at the Connected Services section under your user and license information.
• If you see your SharePoint or OneDrive for Business connection listed, click the Remove link next to it. Confirm the removal if prompted.
• Click the Add a service dropdown menu, select Storage, and then choose Office 365 SharePoint.
• Enter your organizational email address and password to authenticate the connection.

Once you have reconnected your account, restart your Office application. Click File, then Save As, and select Sites - [Your Company] to verify that your frequent cloud locations populate correctly.

Forcing Site Visibility by Following SharePoint Hubs

Microsoft Office populates the default save dialog using an algorithm that tracks the sites you visit and edit most frequently. If you recently joined a new department or rarely visit the web version of a specific site, the algorithm will drop it from your list. You can bypass this automated behavior by manually flagging the site. Understanding this mechanism is a vital alternative for restoring Missing SharePoint Sites in the Office Save Dialog without modifying application settings.

Use these actions to force a site into your save list:

• Open your web browser and log in to your Microsoft 365 portal.
• Navigate to the specific SharePoint site you want to save files to.
• Look at the top right corner of the site header, just below the main Microsoft 365 navigation bar.
• Click the star icon labeled Not following. The icon will fill in and change to Following.
• Return to your Office desktop application.
• Navigate to File, select Save As, and click on your company's SharePoint category.
• Click the Following folder, which is indicated by a pushpin icon. The site you just starred will now be permanently accessible in this directory.

Clearing the Office Document Cache

If your account is properly connected and you are actively following the site on the web, but the desktop application still fails to display it, your local Office cache is likely corrupted. The cache stores temporary directory structures to speed up file browsing. Wiping it forces Word and Excel to download a fresh directory list from Microsoft's servers. For persistent synchronization issues regarding restoring Missing SharePoint Sites in the Office Save Dialog, a cache reset is a highly effective procedure.

Execute this process to clear the cached files:

• Close all running Microsoft Office applications, including Word, Excel, PowerPoint, and Outlook.
• Open Microsoft Word, go to the File menu, click Options at the bottom left, and select Save from the options window.
• Scroll down to the Cache Settings section.
• Click the button labeled Delete cached files.
• A confirmation dialog will appear. Click Delete Cached Files to confirm the action and close the options menu.

Create a blank document and attempt to save it. The application will take a few extra seconds to query the server, after which your updated site list should appear.

Managing Document Workflows with WPS Office

Because the missing SharePoint site issue is inherently controlled by Microsoft accounts, Graph API algorithms, and Windows registry cache files, WPS Office cannot modify or fix these underlying Microsoft-side settings. However, if your Microsoft Office applications consistently struggle to sync cloud locations, you can use WPS Office to manage your documents and connect to cloud storage without relying on Microsoft's unstable "Frequent Sites" algorithm. If you are working to restore missing SharePoint sites in the Office Save dialog, consider bypassing the native dialog entirely with a more straightforward file management approach.

WPS Office provides direct integration with local sync folders. If you sync your SharePoint document library to your local hard drive using the OneDrive desktop client, WPS Office interacts with it consistent.

• Open the SharePoint site in your web browser and navigate to the Documents library.
• Click the Sync button in the top toolbar to link the library to your Windows File Explorer.
• Open WPS Office and click Open on the main dashboard.
• Select Computer, click Browse, and navigate to the new SharePoint icon in your File Explorer's left pane (usually labeled with your company's building icon).
• Open, edit, and save your document natively.

WPS Office saves the file to this local directory, and the OneDrive engine handles the background upload to SharePoint. This method avoids the complex connected services architecture while providing seamless access to your collaborative documents.

Use Word, Excel, and PPT for FREE

Free Download

Frequently Asked Questions

Why do some SharePoint sites appear in the save list while others do not?

Microsoft Office relies on the Microsoft Graph API to populate the Frequent sites list. This background algorithm monitors your activity across Microsoft 365, including the specific web pages you visit, documents you edit, and emails you send. If you have not interacted with a specific SharePoint site recently, the API will not prioritize it, causing it to drop off your list. Manually clicking Follow on the site's web interface ensures it appears in the Following tab regardless of your recent activity.

Can a network administrator disable my access to these saved locations?

Yes. Network administrators can modify SharePoint tenant settings or deploy Group Policy Objects that hide specific connected services. If an administrator disables Microsoft Delve or modifies Graph API privacy settings at the organization level, the Frequent sites list will stop updating for all users. If you have tried reconnecting your account and clearing the cache without success, ask your colleagues if they are experiencing the exact same limitation, which indicates a network-wide policy change.

Does resetting my Office application delete the files I have already saved to SharePoint?

No. Removing a connected service or deleting the Office Document Cache only resets the temporary synchronization data on your local hard drive. Any documents previously saved to SharePoint are safely stored on Microsoft's remote cloud servers. Once you reconnect your account or clear the cache, your desktop application will simply download a fresh index of those existing cloud files without altering the documents themselves.

How long does it take for a newly followed site to show up in Word or Excel?

Under normal network conditions, a site you follow via the SharePoint web interface should appear in your Office desktop application's Following tab within a few minutes. However, the update requires a complete refresh of the server connection. If the site does not appear immediately in the save dialog, close all Office applications completely and reopen them to force the software to ping the server for the updated site index.