May 18 2023 09:44 AM
I have been using group within pivot tables to create up to 4-5 levels. Up till today, I this has been an easy highlight and right-click group. Today, it will not create more than 1 level. I restarted, no luck, so I had IT repair Office, no luck. Then asked others on their machine attempt to do it and no luck. Has something changed overnight? As I was doing it before I left last night?
Here is my build:
Microsoft® Excel® for Microsoft 365 MSO (Version 2304 Build 16.0.16327.20200) 64-bit
May 19 2023 08:28 AM
I don't have access to real-time information about recent changes in Excel like you, but I can try to offer some general troubleshooting steps that may help resolve the problem:
Hope one of the above steps will solve your problem.