Unable to Create a Pivot Table

[ejwjohn]

I am trying to set up a pivot table and i keep getting an error indicating the Name of the Table is not correct. THe only thing that seems to coincide with this error is if i try to select an areas of the original data that contains blank cells.

Can you create a Pivot table with some data cells blank?

Thanks

John

 

[Hermanito]

Blank cells should normally not be an issue...
Total blank rows might be an issue, not sure.

But you have to make sure that each column in your sourcerange has a unique header identification at the top. These cannot be empty!

 

[ejwjohn]

OK, I have three columns that have a general heading accross those three columns (Cells Merged) then there is a unique sub heading for those three cols in the row below the row that are merged ..... is this probably the issue?

John

 

[Hermanito]

is that row with merged cells in the sourcedata range of the pivottable? If yes, I guess that might be the issue...

 

[ejwjohn]

THanks,
Yes learnt somehting there, shared column headers and Pivot Tables are not compatible ...

Thanks

John