Forum Discussion
Object-level security for Analyze in Excel
Hi GilbertQ, this magically started working for me today. There seems to be some sort of conflict when I'm using the test account in Excel but logged into Windows with my main admin account. It seems to be confused about who's accessing the dataset somehow, but I haven't figured out exactly when it happens. So it doesn't look like it's an issue with the object-level security at all, but something account related. Thanks for taking the time to try helping with this!
Hi mmcanelly
It is working for me when I have set up Object Level Security. Can you confirm that you have set the column permissions on the table?
Hi GilbertQ, this magically started working for me today. There seems to be some sort of conflict when I'm using the test account in Excel but logged into Windows with my main admin account. It seems to be confused about who's accessing the dataset somehow, but I haven't figured out exactly when it happens. So it doesn't look like it's an issue with the object-level security at all, but something account related. Thanks for taking the time to try helping with this!