Forum Discussion
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 OK
- there are no external datalinks in the file - the data for the Pivot Table is a Table within the file itself
- the workbook is not protected, but all the sheets are protected with Use Pivot Table and PivotChart Option selected
- the pivot table is t
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.
12 Replies
- Hi gkayne. I experienced the BlueChicken message over the past couple of weeks when trying to open a large file over the 100mb threshold from Excel online (where normally it just advises that I need to open in the desktop app). It has however now disappeared.
My best guess is that it was some internal commentary for Microsoft's dev team that slipped through the net into the live environment. - Can you share the file here for the community to look at?
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.
- How do I share a file?
