Workbook with ODBC query shared by multiple users
Posted on 2012-09-21
I created an Excel 2010 workbook that contains a query to an external data source (a specific query in an Access database). I stored the workbook and the Access db on a network location that's accessible by all users who will use this workbook.
I can flawlessly use this from the machine I originally created the whole thing on but when I open the workbook and try to refresh the query on another user's machine, I get the error "Too few parameters expected". The workbook does contain 2 cells that are used as parameters (a start date and end date) for the query and there doesn't seem to be anything wrong the entries there.
The user has permission to access the network location, the ODBC connection is set up correctly on the user's computer. What am I missing?
More generally: I need for multiple users to be able to successfully run the query without creating individual spreadsheets for each of them. Suggestions please?