mrMadCat
New Member
- Joined
- Jun 8, 2016
- Messages
- 39
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
Hi!
I have one file that has a pivot table with a slicer that started acting weird recently.
When I open it, sometimes slicer in it is not visible, and even if it is, when I click on it only the cells behind it are affected as if there was no slicer at all.
Option Add slicer and Add timeline is greyed out, though option Filter connections is active, and I can see that filter still there and able to check/uncheck it.
I tried saving as it to my desktop. The pattern is the same. Tried deleting tabs, coping tabs inside file, no luck.
It starts working only when I copy tab with data to new file and add new pivot table. But that is not acceptable since this is a complex file shared with team and I don't want to redo much of work again.
May be a way to check or reset some permissions for the file with some macro?
The file is in a SharePoint folder, I open it with excel office 365 desktop. Checked all the updates, checked all update to windows 11 as well. rebooted. File is not in compatibility mode or anything else, it always was and is xlsx file, no macros, one external connection, not protected sheet or workbook.
I have one file that has a pivot table with a slicer that started acting weird recently.
When I open it, sometimes slicer in it is not visible, and even if it is, when I click on it only the cells behind it are affected as if there was no slicer at all.
Option Add slicer and Add timeline is greyed out, though option Filter connections is active, and I can see that filter still there and able to check/uncheck it.
I tried saving as it to my desktop. The pattern is the same. Tried deleting tabs, coping tabs inside file, no luck.
It starts working only when I copy tab with data to new file and add new pivot table. But that is not acceptable since this is a complex file shared with team and I don't want to redo much of work again.
May be a way to check or reset some permissions for the file with some macro?
The file is in a SharePoint folder, I open it with excel office 365 desktop. Checked all the updates, checked all update to windows 11 as well. rebooted. File is not in compatibility mode or anything else, it always was and is xlsx file, no macros, one external connection, not protected sheet or workbook.