I am suddenly having trouble with pivot tables.
I have a simple range, 20 columns by 660 rows, that is the source for my pivot table.
I have a simple pivot table, one row, two columns and the calculated fields option is greyed out. Same thing for more complex versions of the same pivot table.
I tried it with another, existing workbook and the same thing happened. I have a file dated 2 Sept with the option available and not greyed out.
I don't understand why I no longer have the option.
I am running Excel 2016 under Windows 10. My PC at work was recently upgraded to Windows 10 in late August.
Thank you
SRMorgan
I have a simple range, 20 columns by 660 rows, that is the source for my pivot table.
I have a simple pivot table, one row, two columns and the calculated fields option is greyed out. Same thing for more complex versions of the same pivot table.
I tried it with another, existing workbook and the same thing happened. I have a file dated 2 Sept with the option available and not greyed out.
I don't understand why I no longer have the option.
I am running Excel 2016 under Windows 10. My PC at work was recently upgraded to Windows 10 in late August.
Thank you
SRMorgan