When we export a QlikView table (straight table, version 11 qlikview) into excel (Office 2010, windows 7), some of our users are unable to create a pivot table. They get an error message "Data set reference is invalid".
There seems to be no logic about who can and can't do this. When data is copied from an excel sheet to a new sheet, pivoting works fine.
It's got to be a problem with either the users PC or their excel setup, but can anyone point me in the right direction ?