Pivot Table Not Working - Bug in Workbook?

[rwrat]

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?

 

[Andrew Poulsom]

Welcome to MrExcel.

Don't you see the Pivot Table Field List Pane on the right hand side of Excel's window? That's where you choose what should appear in the pivot table.

 

[rwrat]

No there's nothing apart from a blank box and when I click on the blank box the normal things like the field selector or even the pivot section on the ribbon tool bar don't appear.

 

[Andrew Poulsom]

Can you click Field List on the PivotTable Tools Options tab?