+ Reply to Thread
Results 1 to 5 of 5

When trying to get data from an Access model I get the following message

  1. #1
    Registered User
    Join Date
    03-20-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Cool When trying to get data from an Access model I get the following message

    To begin with I don't know if this is the correct forum, but anyway, this is the message I get:

    Could not obtain parameter from reference (bad name or workbook not open) pulling in data from access.


    What I'm trying to do here is that I have a bunch of cells that are supposed to be updated which in turn runs an Access database. When pressing refresh I get this error. I have searched around for it but can't find anything like this.. I don't have any formulas or so in the cells, they are just connected somehow (I wasn't the one who build the model).

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: When trying to get data from an Access model I get the following message

    The code might help.

  3. #3
    Registered User
    Join Date
    03-20-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: When trying to get data from an Access model I get the following message

    Quote Originally Posted by Bob Phillips View Post
    The code might help.
    There is actually no code in the Excel sheet. And concerning the access model I have no idea what part I should copy paste.

  4. #4
    Registered User
    Join Date
    03-20-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: When trying to get data from an Access model I get the following message

    Is there anyone who understands my problem? Or at least where/how I can try to search for a solution?

  5. #5
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: When trying to get data from an Access model I get the following message

    Unless you post your workbook or an example no one is going to be able to help as we have no idea what is causing the error.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1