nirajkrishna
asked on
Data Validation From Other Workbook Problem
I have an Excel workbook that references another Excel workbook for data validation lists. Instead of having both workbooks open, I use Microsoft Query to pull the external Excel table into the current workbook using data refresh. The problem is that the folder that holds the Master Data is pretty sensitive and we do not want people having more than Read only privilages. Only people with Read/Write access are able to refresh properly while those with read only access get an error saying "Unexpected External Database Driver Error ()". How can I make the refresh work for those with Read Only access work properly?
Faustulus
I don't think that it can be done. Therefore you would need a workaround. How about placing your lists in a dependent workbook with access by everyone which gets updated by action from the inaccessible master?
ASKER
Thanks for your answer. I think I understand the concept of what you are saying. Let me look into it and see if it works.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We ended up giving write access to the users with a warning to not modify anything. Not as elegant as an add-in, but workable for this request. Now there is the issue of Excel for the Mac not having any ODBC drivers! Half the users are good and Mac users cannot do anything. Would have been nice to know the Mac requirement right off, so I cold just turn down the job:) No clue how to do anything for that group..........
You might want to check out the Mono project and a .Net implementation for the MAC side of the house. It would be worth opening a new question in the .Net and VB.Net zones, asking about VSTO in a MAC/Mono environment.