I am having issues with pivot tables not working. When creating the pivot after I select the data to pivot and click on the 'Pivot Table' button no pivot table appears. I get may be a blank box that has no functionality. I've tried both options of creating the table in a new sheet or on the same sheet and neither works.
If I take the data into a completely new workbook it pivots fine. Is there a big in my workbook?
I am an expert user in that I know how to create and use pivot tables on a regular basis.
This issue is only happening in this one workbook that I am using and recreating for a number or different customers so it may be that I need to recreate from fresh however I wanted to check if there is something else I can do before doing this?
If I take the data into a completely new workbook it pivots fine. Is there a big in my workbook?
I am an expert user in that I know how to create and use pivot tables on a regular basis.
This issue is only happening in this one workbook that I am using and recreating for a number or different customers so it may be that I need to recreate from fresh however I wanted to check if there is something else I can do before doing this?