Hi,
I have built a tool which is used by several users. There are 7 SharePoint Lists as data sources. I have built one query called 'Connection to Sharepoint Lists' and the 7 other queries are referenced from this. The 'Connection to Sharepoint Lists' query contains only the following:
The trouble is when my users download a copy of the file and click Data > Refresh they need to sign in 7 times, and sometimes this does not even work. They often have to go and clear their global/local permissions from Data Source Settings.
Does anybody know a way around this? All the users are members of the SharePoint site where the data is held.
Thanks very much
Seán
I have built a tool which is used by several users. There are 7 SharePoint Lists as data sources. I have built one query called 'Connection to Sharepoint Lists' and the 7 other queries are referenced from this. The 'Connection to Sharepoint Lists' query contains only the following:
Code:
= SharePoint.Tables("https://acme.sharepoint.com/sites/acmeSite", [ApiVersion = 15])The trouble is when my users download a copy of the file and click Data > Refresh they need to sign in 7 times, and sometimes this does not even work. They often have to go and clear their global/local permissions from Data Source Settings.
Does anybody know a way around this? All the users are members of the SharePoint site where the data is held.
Thanks very much
Seán