Forum Discussion

Copper Contributor

Aug 11, 2021

Temporary views caused by others

everal of us are using an Excel file shared on our company sharepoint. I created several different sheet views based on what task each person is doing that may require them to filter the file. I am...

excel

office 365

Yea_So

Bronze Contributor

Aug 12, 2021

mrlee_75

Power Query:

Each user will have their own workbook querying the main workbook as the data source. They can manipulate their own workbook as much as they like and it would not affect other users who are using the same data source.

cheers