Forum Discussion
Pivot and vlookup
mathetesand SergeiBaklan - thank you for your answers.
Now I have made a light version of the spreadsheet :
On sheet 'Pr. kunde' - in field 'CustAddrNo' :
If I use no. 2001792 everything is fine.
If I use no. 2001811 my lookups are interrupted.
I have tried SergeiBaklan's suggestions and it seems to be text now.
How did that happened ? (I know it happened when I by a mistake overwrite the number and then changed it back - but why did it then became text ?)
How do I correct it ?
And how do I prevent other users to do the same failure ?
Hope you can help 🙂
I didn't find exact reason, but if re-build PivotTable it works. Most probably something with caches. Please check attached.
Hello again,
I have now rebuild the pivot, but I can still enter a non-existing number in the filter and then I get this warning/question "No item of this name exists in the Pivottable report. Rename '2001811' to '8888888'?". See attached.
How do I prevent this ?
In your example I can only enter existing number, which is what I want.
My guess an error appears if you work with macros, but that's not my territory. If not, could you please share how to reproduce it on the workbook without macros.
