ExcelBanter - ribbon and pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - ribbon and pivot table (https://www.excelbanter.com/excel-worksheet-functions/160686-ribbon-pivot-table.html)

Lori

ribbon and pivot table

I am attempting to create a pivot table, but the ribbon has that option
"greyed out". How can I make this option available on the ribbon?

Bernard Liengme

ribbon and pivot table

I cannot reproduce this even with an empty worksheet
Try a new sheet just in case the current one has something special
preventing pivot tables
Then come back to us
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Lori" wrote in message
...
I am attempting to create a pivot table, but the ribbon has that option
"greyed out". How can I make this option available on the ribbon?

All times are GMT +1. The time now is 10:57 AM.