Pivot Table Not Working - Bug in Workbook?

rwrat

New Member
Joined
Feb 25, 2016
Messages
2
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?
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

New Member
Joined
Feb 25, 2016
Messages
2
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,519
Messages
5,596,635
Members
414,083
Latest member
Mrsash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top