Data Refresh for Excel Files Shared in Teams

%3CLINGO-SUB%20id%3D%22lingo-sub-3214239%22%20slang%3D%22en-US%22%3EData%20Refresh%20for%20Excel%20Files%20Shared%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3214239%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20Teams%20account%20through%20my%20company.%26nbsp%3B%20I%20want%20to%20share%20Excel%20files%20that%20have%20Access%20queries%20tied%20to%20them.%26nbsp%3B%20The%20Access%20database%20queries%20on%20stored%20on%20our%20local%20company%20server.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20share%20the%20file%20internally%20from%20OneDrive%2C%20users%20are%20able%20to%20refresh%20the%20queries%20with%20no%20issue.%26nbsp%3B%20However%2C%20if%20I%20drag%20the%20file%20to%20Teams%2C%20a%20refresh%20of%20the%20query%20gives%20a%20%22Data%20Refresh%20Failed%22%20error.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%20on%20how%20to%20get%20internal%20files%20to%20refresh%20on%20Teams%20when%20using%20Teams%20internally%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3214239%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Efiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20%26amp%3B%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3218620%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Refresh%20for%20Excel%20Files%20Shared%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3218620%22%20slang%3D%22en-US%22%3EHave%20you%20actually%20try%20to%20access%20the%20files%20through%20the%20SharePoint%20UI%3F%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a Teams account through my company.  I want to share Excel files that have Access queries tied to them.  The Access database queries on stored on our local company server.  

 

When I share the file internally from OneDrive, users are able to refresh the queries with no issue.  However, if I drag the file to Teams, a refresh of the query gives a "Data Refresh Failed" error.  

 

Any suggestions on how to get internal files to refresh on Teams when using Teams internally?

2 Replies
Have you actually try to access the files through the SharePoint UI?

@Juan Carlos González Martín 

 

I'm not exactly sure what you mean.  I opened Sharepoint.  I see the files.  Opening them in a browser from Sharepoint gives the same error.  Are you suggesting the user download the file and try to update the data?