= Excel.CurrentWorkbook(){[Name="Table1"]}[Content]

[THOMAS_GOOSSENS]

Dear Community,

I’ve created an Excel template (.xlsx) that includes several Power Query queries linked to tables within the same file.

However, when I share the template—either internally or externally—users receive an error message when they try to refresh the queries. The error refers to a SharePoint folder where the original template was saved, to which they don’t have access.

Despite this, clicking "OK" allows the refresh to proceed successfully.

Is there a way to eliminate this initial error message entirely?

Thank you in advance for your help!

[v-sgandrathi]

Hi @THOMAS_GOOSSENS,

You're absolutely right that a hidden SharePoint reference is likely embedded within the template. To fully resolve the issue:

1. Open Power Query Editor and review each query’s Advanced Editor to ensure there are no lingering steps or references pointing to external sources like SharePoint.
2. Go to Data > Connections and remove any old or unused connections that may still point to the SharePoint location.
3. After cleaning up both queries and connections, save the file as a new template (.xltx) and share that version instead.

These steps should eliminate the SharePoint error message for all users and ensure a smooth experience when refreshing queries.

I hope this helped! Feel free to ask any further questions. If this resolved your issue, please mark it as "Accept as Solution" and give us Kudos to assist others.

Thank you.

[v-sgandrathi]

Hi @THOMAS_GOOSSENS,

We wanted to check if you had a chance to review our last reply. Let us know if it helped or if you need more guidance, we're always happy to help further.

If the solution worked for you, please click Accept as Solution and feel free to leave a Kudos for visibility.

Looking forward to hearing from you!

[ronrsnfld]

Possibly there's a reference to the sharepoint path within the template that needs to be removed.