Forum Discussion
Excel PivotTable in Browser
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 Figured out I needed to edit and upload the file to the original post...
I attached a file prepared that duplicates this behavior - note the follow observations are included in Column D of the attached file:
1. All Sheets are protected without a password.
2. "Admin" showing in the PM Designation Slicer does not exist in the Pivot Table's Data Source (tblProjectManagers).
3. This was an option in a prior Table connected to the Pivot Table as its Data Source. Note the format in the Field Header Row changes when "PM's Designation Slicer" is filtered to only "Admin"
4. The Field Header Row would normally be excluded, but is shown here to demonstrate the above effect.
5. You can avoid the initial error message when opening the sheet if you unselect the PivotTable's "Refresh data when opening file" option - but you are still unable to refresh the data.
6. After working with it for a while, I think the inability to refresh the data is by design. When the sheet is protected, it really is essentially meant to be read-only, so as long as the PivotTable is refreshed before sharing it with others, it works fine.
7. However, I still do not understand why there is a record showing in the Pivot Table's Slicers that does not exist in its data source.
8. Finally "What is BlueChicken"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.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.
- How do I share a file?
