Forum Discussion
Pivot and vlookup
It sounds like you've done a reasonable search for possible causes. Is it possible for you to post a copy of the spreadsheet(s), just making sure first to remove any actual names, addresses, etc.--i.e., any and all confidential or personal info.
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.
