Why does number 160 and 164 not appear in my excel pivot table

[goodluckboss]

Hi guys

For the life of me, I cannot understand why number 160 and number 164 does not appear in my excel pivot table

I tried changing it to 1600 and it came out but when I switched it back to 160 it disappears again.

Will attach a sample excel for your reference

EDITED TO LINK TO SHEET1

My apologies

[josephteh]

Your PivotTable is not linked to data in Sheet1, but to an external source: 'P:\qOO dELIVERY\[Orders Printing Shopee.xlsm]Sheet1'!$A:$A

[goodluckboss]

Hi there changed it to link to the correct Sheet. So sorry perhaps it was when I was removing some sensitive data it was linked to pcloud

[oeldere]

make a new PivotTable of the data in sheet 1 and it will be working.

[goodluckboss]

Yeah I tried that but it breaks after a while. Not sure why. Is it a bug? Or did I do something wrong?

[alansidman]

When I pivot your data it works out just fine. Look at the attached.

[goodluckboss]

Yeah if you do a new pivot it works but does anyone know why the old pivot is missing those numbers?

Thanks all for the responses Appreciate it a lot

[josephteh]

Looks like a bug. If you group and then ungroup the field, 160 and 164 will reappear.