Strange Issue with pivot table - doesnt see blank

[jaryszek]

Hi Guys,

i have pivot table which instead of (blank) shows "" after refresh.
Data source is listobject.

Why?
How to avoid this?

I am building Dropdown list from it and it causes a lot of issues because i do not have any value in drop down...and want to have blank there.

Screenshot_31.png

Please help,

Best,
Jacek

[Shareez Saleem]

Select column A (excluding header) in Sheet 1, press delete and refresh the data.
Recommending to recreate Pivot Table after doing the above said step.

[jaryszek]

Thank you,

but what is causing it?
How to detect that source table has issue?

I have to avoid this.

Jacek

[Shareez Saleem]

In order to detect the unseen info., just select the range and see the count below. If it showing nothing, it means blank else it has something.
Delete it if it's not required.

[jaryszek]

Thank you!

Jacek