VBA learner ITG
Active Member
- Joined
- Apr 18, 2017
- Messages
- 272
- Office Version
- 365
- Platform
- Windows
- MacOS
#need advice
I have created a power query to transpose data from a worksheet from an excel workbook on a SharePoint site to another workbook in the same SharePoint site.
Q1. Is it correct that you need to open both excel files in the Excel App to update/refresh the queries and this cannot be done by clicking and editing through a web browser when viewing/editing the excel files?
Q2. If i no longer have site permission to the Sharepoint Site even though I am the author of the workbook could other people refresh the queries.
I have created a power query to transpose data from a worksheet from an excel workbook on a SharePoint site to another workbook in the same SharePoint site.
Q1. Is it correct that you need to open both excel files in the Excel App to update/refresh the queries and this cannot be done by clicking and editing through a web browser when viewing/editing the excel files?
Q2. If i no longer have site permission to the Sharepoint Site even though I am the author of the workbook could other people refresh the queries.
