Workbook with ODBC query shared by multiple users

Posted on 2012-09-21
Last Modified: 2012-10-09

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?

Many thanks!
Question by:monkeybiz12345
    LVL 14

    Expert Comment

    To me it sounds like it cannot find the ODBC connection because it is not on the other computers. I know you can query without creating ODBC connections on the PC but the code has to be written differently.

    Accepted Solution

    Thanks for trying, Peetjh.  However, the ODBC data source is set up correctly and working properly on all the computers that need to access this spreadsheet.

    For now, I've decided to create multiple local copies for each user that needs access. I just wanted to avoid doing that so I don't have to maintain it in multiple places.

    Author Comment

    Hmm... when I requested attention for this question, modus_operandi suggested that Peetjh might've been referring to a DSN that was not present on all machines.  Could be...  I'll check that out next time I think of it and post back here if that leads to more information about the problem.

    Author Closing Comment

    Creating a separate copy of the spreadsheet on each user's machine was the solution I was trying to avoid but that's how I ended up working around it.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now