Forum Discussion
PivotTable Date Slicer Not Visible in Excel for the Web (Works in Desktop)
Hi everyone,
I'm experiencing an issue with Excel for the web and was hoping to get some help.
I have an Excel workbook that is linked to a 'Microsoft Forms' form. The form responses automatically populate the main sheet, and from that data I've created several PivotTables.
In one of the PivotTables, I added a date slicer to filter the data. Everything was working fine at first, but recently the slicer is no longer visible in Excel for the web. However, when I open the same workbook in Excel Desktop, the slicer is visible and it works as expected.
What I have tried so far:
- Recreating the PivotTable and adding a new slicer
- Creating a completely new PivotTable and slicer
- Checked if the slicer is hidden by adjusting the zoom
Unfortunately, the issue persists in Excel for the web.
Has anyone experienced this before and found a workaround?
Any help would be appreciated.
Thanks in advance.
1 Reply
It seems there is a difference in Web Excel capabilities, depending on how your tenant is set up. See:
https://support.microsoft.com/en-us/office/differences-between-using-a-workbook-in-the-browser-and-in-excel-f0dc28ed-b85d-4e1d-be6d-5878005db3b6 On that page, it says this about slicers and timeline slicers:
"Filters and slicers generally work in a browser window similar to how they work in Excel. In general, timeline controls work in a browser window similar to how they work in Excel.If you are using Excel Services or Excel Web App on premises (not in the cloud), the ability to display certain content in a browser window depends on whether Excel Services or Excel Web App is used to display a workbook."
