File Format & Compatibility

Fix Missing Excel Cell Styles in SharePoint 2016 Excel Web Access

Steve KSteve K Nov 22, 2026 868 views

Question details

Display Excel cell styles with patterned fills on a SharePoint 2016 page.

Fix Missing Excel Cell Styles in SharePoint 2016 Excel Web Access
Product
SharePoint Server 2016 Excel Web Access and Microsoft Excel
Device & OS
not provided
Scenario
A workbook with custom cell styles is displayed in an Excel Web Access web part.
Observed behavior
Patterned fills appear in desktop Excel but do not display in the web part, even after the styles are recreated.
Before you start

Open the workbook in desktop Excel and identify the cells that use patterned fills. Compare the workbook in Excel Online to check whether the same formatting is missing in the browser.

Solution 1Recommended

Replace patterned fills with solid colors

Use solid fills if the workbook needs to remain interactive in Excel Web Access.

Excel Web Access may not render Pattern Style fills even when desktop Excel displays them correctly. Replacing the pattern changes the workbook's appearance but avoids relying on that fill effect.

1
Select affected cells

Open the workbook in desktop Excel and select the cells whose patterned fills are missing.

2
Change the fill

On the Home tab, open the Fill Color menu and select a solid color. Repeat for other affected cells or styles.

3
Save and check

Save the workbook to its SharePoint location, refresh the page containing the Excel Web Access web part, and check the fills.

Replace patterned fills with solid colors
Free Microsoft Office alternative

Edit Excel Workbooks with WPS Spreadsheet

WPS Office is a free, lightweight alternative for opening and editing Office files. Its familiar interface and format compatibility make it easy to move existing workbooks into WPS, though it does not change how SharePoint Excel Web Access renders them.

Review and edit cell formatting in WPS SpreadsheetOpen and save Microsoft Excel XLSX filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does the pattern appear in Excel but not in SharePoint?

Excel Web Access does not display some cell styles that use Pattern Style fills, even though desktop Excel can render them.

Will recreating the custom cell style fix the missing pattern?

Not necessarily. If the issue is the web renderer's support for patterned fills, recreating the same style will not make the pattern appear. Try a solid fill or a PDF instead.

How can I check whether the issue is limited to one workbook?

Open another workbook with a patterned fill in Excel Online and compare it with the desktop Excel view. You can also test the original workbook in both views.

Can viewers edit the worksheet in the embedded PDF?

No. A PDF is a static representation of the worksheet. Keep the workbook available separately if users need to edit or interact with it.