Pivot table field name is not valid error by excelquicktips

You can bump into this error when you're trying to create a pivot table.

- - - - - -

[abegailampig]

You're a life saver!! I've watched plenty of videos already and yours is the most simplest AND effective!

[barbboca]

My boyfriend just asked me if I knew anything about pivot tables in excel and this error. I said no but I know how to use the search bar in YouTube 😂. Thanks for making me look brilliant. 👍

[disneyplus]

OMG... you are a life saver... I badly needed this to resolve my reports and boom straight to the point... Thank you much for this

[gabriela_sd]

Problem finally solved! Thank you so much! Short and to the point, great video!

[ran]

You, sir, have earned a thumbs up from me! Thank you for the video. May I add that not only when you have hidden columns but also when you have merged cells that this problem comes about. Problem solved!

[mrmslv]

GOD THANK YOU YOU ARE A LIFE SAVER! i have a project due tmw😭😭😭

[suryaismail]

You're a life saver me on my work, thx u so much:)

[maheshrathod]

you are god i worship you you literally solved my issue

[brijeshnarayan]

Yes thank you so much, you are a Life Saver

[simbotist]

Didn't work for me, I have no hidden columns, or empty columns, still have the error. Thanks though

[alehaaz]

Thank you thank you thank you!

I have an excel thing due tomorrow and I was losing my mind!
Thank you!

[amaregebeye]

Thank you so much for your important message

[TheRoadtoFinalLight]

Great advise. Thank you for posting it.

[FoodLiquorCool]

I join the commenters in saying thank you good sir!

[Durgakhagga]

What if the error when their are no blank headers? Or no hidden cols?

[kervensbenjamin]

Everything disappear when i click on hide

[vinuji]

I have date as a column name in my excel sheet. Showing this error