Error with User Data

I have a report that is using 'user data' but some users occasionally receive the following error



'Error Loading user data for sheet 'Variations'


The user data cells $O$9 and $P$9 have been assigned duplicate keys. Each user data cell must contain a unique key. The offending key value is:



Value: VAR 1, -2146826273


User data will not be saved for this sheet.


The sheet is fairly complex (for me!) and does contain various keys/keynames, some of which are generated from data from Dynamics Nav. I cannot replicate on my machine so I don't think there are actually duplicated keys but I don't know how to resolve. The users having problems have viewer licences and I have a designer licence but I can't see how that would make a difference. I don't know where to start to resolve the problem.


Please sign in to leave a comment.