Share via

Re-Link Query to Excel Table

Anonymous
2024-08-29T15:57:34+00:00

I have a query that loads to an Excel table. However, the query spontaneously (yes, spontaneously) de-linked and turned into Connection Only. I tried to re-link the query by going to Data, Queries & Connections, right-clicking on the query, Load To and pointing it to the worksheet and top left cell ($A$1) where the table is located. However, I get the error "Query results cannot overlap a table or XML mapping".

How can I re-link the query to the table it is supposed to populate?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Andreas Killer 144.1K Reputation points Volunteer Moderator
2024-08-30T04:29:54+00:00

Unfortunately there is no way to reconnect a query.

  1. Load the query below the existing table.
  2. If you have formulas that refers to your old table use Search&Replace to replace the old table name with the new table name.
  3. If you have formulas inside the old table, copy this to the new table and use Search&Replace to remove the old table name.
  4. Delete the old table
  5. Move the new table into the place of the old table.

After this your file looks the same as before.

Andreas.

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest