How to Fix Excel for the Web Zoom Resetting to 100% in SharePoint
Question details
The user needs to maintain a custom zoom level (such as 70%) in a SharePoint-linked Excel workbook instead of having it constantly revert to 100%.

- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- Reopening an Excel workbook that is hosted on a SharePoint site using a web browser.
- Observed behavior
- Excel for the web ignores the previously saved zoom level and automatically forces the workbook to open at a default 100% zoom every time.
Verify whether you are opening your SharePoint workbook in a web browser or the desktop application, as their abilities to save view preferences differ significantly.
Open the Workbook in the Excel Desktop Application
Since Excel for the web cannot save custom zoom levels, opening the file in the desktop application allows your zoom preferences to be saved properly.
Excel for the web is designed for quick viewing and editing, but it currently lacks the feature to remember a specific zoom level upon reopening. By routing the file to your desktop app, you bypass this web limitation and retain full control over your view settings.
Navigate to your SharePoint document library in your web browser and find the Excel workbook you want to edit.
Click on the three dots (ellipses) next to the workbook's file name to reveal the options menu.
Select 'Open' from the dropdown menu, then click 'Open in app' to launch the file directly in your Excel desktop application.
Use the zoom slider at the bottom-right corner of the Excel window to set your view to your desired percentage (e.g., 70%), then save the document. The desktop app will remember this setting for future sessions.

Experience Seamless Spreadsheet Management with WPS Office
Tired of web-based limitations in Microsoft Excel? WPS Office provides a robust, free, and lightweight desktop alternative that perfectly preserves your zoom settings and view preferences. Enjoy full compatibility with Microsoft Office files without the frustrating online quirks.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your device.
- 2. Open your spreadsheet: Launch WPS Spreadsheets and open your downloaded SharePoint workbook.
- 3. Save your preferences: Adjust your zoom settings as desired; WPS will reliably remember your configuration for the next session.

Frequently Asked Questions
Why does Excel for the web reset my zoom to 100% every time?
Microsoft Excel for the web does not currently have a built-in setting to save default zoom levels. It is programmed to reset the view to 100% upon every new web session, regardless of the zoom level previously saved in the file itself.
Can I fix the zoom issue by changing my SharePoint settings?
No, this is an inherent limitation of the Excel for the web application, not a SharePoint configuration issue. SharePoint simply uses Excel for the web as its default document viewer, which triggers the 100% zoom override.
Does zooming out in my web browser fix the problem permanently?
Using your browser's zoom function (such as pressing Ctrl and the Minus key) scales the entire web page interface, but it does not change the native zoom setting inside the Excel file. Your browser zoom may also reset if you clear your cookies or use a different device.




