File Cannot Open

Fix Excel 365 Opening a Blank XLSM File from SharePoint Server

Elise WilliamsElise Williams Nov 20, 2026 868 views

Question details

The user needs to open a macro-enabled workbook stored on SharePoint Server in Excel for Microsoft 365.

Fix Excel 365 Opening a Blank XLSM File from SharePoint Server
Product
Excel for Microsoft 365 and SharePoint Server
Device & OS
not provided
Scenario
Opening an XLSM workbook from a SharePoint Server document library in Excel.
Observed behavior
Excel may display a blank worksheet instead of the workbook contents.
Before you start

Confirm that the workbook is stored on SharePoint Server, not SharePoint Online, and note the workbook name and document-library location. Ask your SharePoint administrator for the server version if you do not know it.

Solution 1Recommended

Compare opening the XLSM file from SharePoint and locally

Use this check to help determine whether the blank display is related to the server connection or the workbook itself.

1
Open the workbook from the library

In the SharePoint Server document library, select the XLSM file and use the available option to open it in Excel. Note whether Excel displays the workbook contents or a blank worksheet.

2
Test a local copy

If your organization permits it, select the file in the library and choose Download. In Excel, use File > Open to open the downloaded copy and compare the result.

3
Compare another file

From the same document library, open another workbook in Excel. If possible, ask an authorized colleague to test the affected XLSM file and record whether they see the same behavior.

Compare opening the XLSM file from SharePoint and locally
Interpret the results: A local copy that opens correctly can help point the investigation toward the SharePoint connection or library configuration, but it does not establish the cause.
Free Microsoft Office alternative

Work with Excel Files Using WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. It can help you move between compatible spreadsheet formats, although it does not fix SharePoint Server authentication or configuration issues.

Open and work with compatible Microsoft Excel formats, including XLSX and XLSMUse a familiar spreadsheet interface for everyday workbook tasksMove existing Office documents into a lightweight productivity suiteAccess free spreadsheet tools alongside document and presentation apps
microsoft office alternative - wps office

Frequently Asked Questions

How can I tell whether SharePoint is involved in the blank workbook issue?

Download the XLSM file from the SharePoint Server library, if permitted, and open it through Excel's File > Open menu. Compare that result with opening it directly from the library; the difference can help your administrator investigate.

What should I tell my SharePoint administrator?

Provide the SharePoint Server version, library location, Excel version, and whether the file opens locally or for another authorized user. Ask the administrator to check authentication, compatibility, and library configuration.

Is this the same as an XLSM issue in SharePoint Online?

Not necessarily. SharePoint Server has its own environment and configuration, so seek guidance specific to SharePoint Server rather than assuming SharePoint Online instructions apply.

Should I disable macro security to make the workbook appear?

Do not disable security settings just to test the blank display. First compare the SharePoint and local opening results, then ask your administrator to investigate the cause.

Can WPS Office fix the SharePoint Server connection?

No. WPS Office is an alternative for working with compatible Office files, but SharePoint Server authentication and library configuration must be investigated in the Microsoft environment. Check macro compatibility before relying on an XLSM workbook in another application.