Office Settings & Configuration

How to Fix Excel for the Web Zoom Resetting to 100% in SharePoint

Rana GarciaRana Garcia Oct 12, 2026 871 views

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%.

How to Stop Excel for the Web Zoom from Resetting 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.
Before you start

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.

Solution 1Recommended

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.

1
Locate the file in SharePoint

Navigate to your SharePoint document library in your web browser and find the Excel workbook you want to edit.

2
Open the context menu

Click on the three dots (ellipses) next to the workbook's file name to reveal the options menu.

3
Launch in desktop app

Select 'Open' from the dropdown menu, then click 'Open in app' to launch the file directly in your Excel desktop application.

4
Set and save zoom level

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.

Open the Workbook in the Excel Desktop Application
Submit Feedback to Microsoft: Because this is a known functional limitation of Excel for the web, consider voting for a default zoom feature on the official Microsoft Feedback Portal to encourage future updates.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your device.
  2. 2. Open your spreadsheet: Launch WPS Spreadsheets and open your downloaded SharePoint workbook.
  3. 3. Save your preferences: Adjust your zoom settings as desired; WPS will reliably remember your configuration for the next session.
Free and lightweight desktop alternative to Microsoft Office.Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Reliably saves your customized zoom levels and workspace views.Familiar user interface for a seamless and immediate transition.
microsoft office alternative - wps office

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.