Forum Discussion

gkayne's avatar
gkayne
Copper Contributor
Jan 23, 2022
Solved

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 ...
  • NowshadAhmed's avatar
    NowshadAhmed
    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.

Resources