Results 1 to 2 of 2
  1. #1
    smatchymo is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2019
    Posts
    15

    Excel power query linked to access query opens query related spreadsheets and returns an error

    I have an Access Database with a few linked spreadsheets: supplier list, contact list, and prepaid freight thresholds. I want the spreadsheets to be linked because they are being updated with new information occasionally. The query works without any issues in the access database. I have a power query in excel linked to this query and it worked at first, but within a few attempts it started opening up the spreadsheets used in the query. I first get a notification saying "'particular file.xlsx' is now available for editing. Choose Read-Write to open it for editing." I think I've gotten a couple different error messages after selecting cancel instead of Read-Write, but one that I'm for sure getting is "[Expression.Error] The key didn't match any rows in the table." What am I doing wrong?

    I have a couple of other spreadsheets that have queries linked to Access queries and they work fine without opening any spreadsheets, but the person that created those no longer works with the company.

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 03-26-2019, 12:40 PM
  2. Replies: 5
    Last Post: 11-15-2018, 10:46 AM
  3. Replies: 3
    Last Post: 07-28-2015, 09:47 AM
  4. Replies: 1
    Last Post: 07-23-2015, 05:11 AM
  5. Replies: 14
    Last Post: 03-31-2015, 05:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums