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 ...
Excel for web
  • NowshadAhmed's avatar
    NowshadAhmed
    Jan 23, 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's avatar
NowshadAhmed
Iron Contributor
Jan 23, 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.

gkayne's avatar
gkayne
Copper Contributor
Jan 23, 2022

The BlueChicken reference is shown in the image included in my original post - this error message occurs when I initially load the file from my Web Browser (Edge) or from Teams. It also occurs when changing between Editing and Viewing in the Browser since Excel is essentially reloading the file. I cannot find any reference within MS to BlueChicken.  

  • NowshadAhmed's avatar
    NowshadAhmed
    Iron Contributor
    Jan 23, 2022
    WAC ULS is referring to Office Web Apps Server.

    You may contact your administrator or check the link below, if you find answers.

    https://www.c5insight.com/Resources/Blog/tabid/148/entryid/837/troubleshooting-office-web-apps-ssl-issues.aspx
    • gkayne's avatar
      gkayne
      Copper Contributor
      Jan 23, 2022
      Thanks again - I'll look into it.
      • mtarler's avatar
        mtarler
        Silver Contributor
        Jan 27, 2022

        gkayne NowshadAhmed Just so you know you aren't crazy, I got a reference to BlueChicken also:

        the link in the bottom to usc-excel.officeapps.live.com/... is that BlueChicken Troubleshooting Documentation link...

        But in my case the file does NOT open/load