Fix Missing Excel Cell Styles in SharePoint 2016 Excel Web Access
Question details
Display Excel cell styles with patterned fills on a SharePoint 2016 page.

- 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.
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.
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.
Open the workbook in desktop Excel and select the cells whose patterned fills are missing.
On the Home tab, open the Fill Color menu and select a solid color. Repeat for other affected cells or styles.
Save the workbook to its SharePoint location, refresh the page containing the Excel Web Access web part, and check the fills.

Export the worksheet as a PDF and display it on a classic page
Use a PDF when preserving the pattern's appearance is more important than workbook interactivity.
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.

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.




