PivotTable ghost values

[SergSlim]

Hello.

I'm creating a PivotTable with DataSource set to Установка!$B:$J
Whenever I do it, and select which fields will be rows - I get some old values in dropdown list for rows.
I can't find this value by search in the whole workbook.

Also if I set range to Установка!$B1:$J1048575 - I don't get these ghost values.

I deleted and created PivotTable again, but still these values are added each time. This is very odd, as I can't find where does it take these old deleted values.
Of course I can just uncheck these values, so that they won't be shown as rows, but I don't want them to be shown at all.

Does anyone have any ideas regarding this problem?

[dilipandey]

Hi SergSlim,

This may be because of pivot cache. Suggest you to search internet for "Excel pivot cache clear" and you'll get your answer there


Regards,
DILIPandey
<click on below * if this helps>

[SergSlim]

Hi SergSlim,

This may be because of pivot cache. Suggest you to search internet for "Excel pivot cache clear" and you'll get your answer there


Regards,
DILIPandey
<click on below * if this helps>

Thanks, this helped..

[dilipandey]

great

Please mark this thread as [SOLVED]...thx



Regards,
DILIPandey
<click on below * if this helps>