It might happen that when you try to create a Pivot Table an error ‘The Pivot Table name is not valid’ appears especially if you work with a third-party data.

99% of this problem lies in the additional columns. I will show you my example:

You can see that D column is empty. It was hidden and not particularly obvious though. Indeed, deleting this kind of columns let you to successfully create the PivotTable.

--

--

Ksenia Udovitskaia

Ksenia Udovitskaia

A Munich-based Business Analyst and Data Visualizer