Share via

Copy and paste a query into another workbook while maintain the link to the source

Anonymous
2024-10-11T09:31:33+00:00

Hello,

I used Append in Power Query Editor to append two queries and create one table to see the total number of points taught by each faculty. When I'm trying to copy and paste this query (or all the queries) from one workbook into another while maintaining the source, I keep getting the errors below and "Download did not complete"

What am I doing wrong?

Microsoft 365 and Office | Excel | For business | 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 No comments

3 answers

Sort by: Most helpful
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2024-10-11T13:31:21+00:00

    As described in the article I mention, upload to an online file hoster and post the download link here.

    Andreas.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-10-11T12:25:06+00:00

    Thank you Andreas,

    How can I post /send a sample file?

    Was this answer helpful?

    0 comments No comments
  3. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2024-10-11T10:12:52+00:00

    Your new workbook did not contain the source(s) of your queries. In this case at min. Table1 is missing in the other file.

    If you need further help, we need to see your (sample) file.
    Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

    Andreas.

    Was this answer helpful?

    0 comments No comments