Share via

Refreshing PowerQuery in a Shared Excel Workbook stored on SharePoint

Anonymous
2022-02-01T21:22:12+00:00

I've created a number of Power Query data pulls in an excel file hosted on Teams (SharePoint backend) that our team use constantly every day, it is typical that at least 2-4 people have this open on their laptop all day every day... I want to make sure people are always looking at the most correct data, so I had set the Queries to refresh on file open and every 60 minutes, so that even if I'm not around the data is valid. However, it throws up an error and says refresh is paused due to multiple people being in the file at the same time...

My question is, I can manually hit refresh all and have it refresh all the data fine regardless of how many people are in the worksheet, so is there any workaround for this automated error? N.B. I tried automating a script to refresh it with Power Automate, but excel online doesn't seem to like refreshing the queries to external datasources...

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

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-04-12T02:50:22+00:00

    hi tin,

    i have a probelm is can not share workbook, becausei have a access database connect in Excel POWER QUERY.

    the error : "this workbook cannot be shared because it contains Excel tables or XML maps. To share this workbook, convert the tables to ranges and remove the XML maps."

    how can i make the Excel file Share Workbook?

    0 comments