Forum Discussion
Data Connection Refresh Error
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...
Hi Jan,
Thanks for your reply. The file address is a Sharepoint path and not a local path. It has been connected just like the instructions in the link you have sent.
Thanks for your reply. The file address is a Sharepoint path and not a local path. It has been connected just like the instructions in the link you have sent.
One of possible reasons if in desktop application privacy level were ignored. Cloud services ignore such ignorance and take about the privacy levels.
That's easy to check - on desktop change setting on Combine privacy levels and Refresh All. If works - something else. If not - rebuild your query.
Thanks for your reply. Could you guide me on how to Combine privacy levels and could not find such an option in Excel.
I found the settings as attached. Looks okay but still does not refresh data when accessed on online version.
You may try on another computer in local folder(s) and desirable not in your environment. If error, perhaps it tries to connect to your laptop or on-premises source.
