Hi, I'm a newbie that tried searching for solutions, but no solution seems to work.
I'm trying to automate my actions to pivot a table and then group 8 columns into 3 new columns and rename the 3 new columns.
However, my excel crashes between the times that I try to group new columns or renaming the new columns.
I've tried the following solutions to no avail:
1) Options -> Advanced -> (uncheck) extend data range formats and formulas
2) copy and pasted my data into a new spreadsheet
3) convert all text to numbers for those flagged with error
4) do initial actions without automation and try at the group stage to record actions
5) run initial actions with automation and edit code to add group
6) data does not have any formulas
Currently using Microsoft 365 for Enterprise, version 2410 (build 18129.20200)
Please help this desperate soul... thanks in advance!
I'm trying to automate my actions to pivot a table and then group 8 columns into 3 new columns and rename the 3 new columns.
However, my excel crashes between the times that I try to group new columns or renaming the new columns.
I've tried the following solutions to no avail:
1) Options -> Advanced -> (uncheck) extend data range formats and formulas
2) copy and pasted my data into a new spreadsheet
3) convert all text to numbers for those flagged with error
4) do initial actions without automation and try at the group stage to record actions
5) run initial actions with automation and edit code to add group
6) data does not have any formulas
Currently using Microsoft 365 for Enterprise, version 2410 (build 18129.20200)
Please help this desperate soul... thanks in advance!
