Forum Discussion
gkayne
Jan 23, 2022Copper Contributor
Excel PivotTable in Browser
This error occurs when I try to open the Excel file in Teams or using the Browser (MS Edge). What is BlueChicken? Note: the excel file opens and seems to be working fine after pressing ...
- Jan 24, 2022
Try this:
In the slicer settings, uncheck 'show items deleted from the data source' (para-phrasing).
If the above option is not available (depends on your excel version), check 'hide items with no data'
The formatting changes to indicate 'no data' for that filter. In your case, Admin.
I checked by changing one PM Designation to Admin. Refreshed. It works fine!
I didn't see anything about BlueChicken on the file you shared. Even when refreshing data on protected sheets. Check with your work place, if it has anything to do with cloud servers and network sharing.
NowshadAhmed
Jan 23, 2022Iron Contributor
Can you share the file here for the community to look at?
gkayne
Jan 23, 2022Copper Contributor
How do I share a file?