Hi. I have successfully been able to import data (in File No. 1) from another excel file (File No. 2). Both these files are stored in Sharepoint and are collaborated with a team. These files also can be accessed thru the Files Tab in a Teams Channel. These files are also stored on my Laptop and can be accessed via OneDrive/Sharepoint. When I open the file from my laptop and perform Data Refresh , the connection is successful and the refreshed data gets imported (i.e. New Data from File No. 1 to File No. 2). When I access the same file thru Teams (or excel online), I get a refresh error as below.
Other users who try to Refresh the File (File No. 2) also get the same error. Appreciate if I can get a solution.
