Temporary views caused by others

%3CLINGO-SUB%20id%3D%22lingo-sub-2636601%22%20slang%3D%22en-US%22%3ETemporary%20views%20caused%20by%20others%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2636601%22%20slang%3D%22en-US%22%3E%3CP%3Eeveral%20of%20us%20are%20using%20an%20Excel%20file%20shared%20on%20our%20company%20sharepoint.%26nbsp%3B%20I%20created%20several%20different%20sheet%20views%20based%20on%20what%20task%20each%20person%20is%20doing%20that%20may%20require%20them%20to%20filter%20the%20file.%26nbsp%3B%20I%20am%20in%20the%20main%20default%20view%20quite%20a%20lot%2C%20so%20I%20see%20multiple%20changes%20which%20is%20no%20problem.%26nbsp%3B%20The%20issue%20we%20are%20having%20is%20that%20when%20others%20turn%20on%20one%20of%20the%20sheet%20views%2C%20my%20default%20view%20will%20become%20a%20temporary%20view%20for%20me.%26nbsp%3B%20If%20I%20hit%20'exit'%20to%20go%20back%20to%20the%20default%2C%20now%20I%20see%20the%20sheet%20view%20the%20other%20person%20is%20using.%26nbsp%3B%20They%20say%20they%20havent%20closed%20the%20file%20in%20the%20view.%26nbsp%3B%20I%20can%20remove%20the%20filters%20and%20close%20the%20file%20to%20reset%20the%20Default%20view%2C%20but%20a%20couple%20of%20minutes%20after%20reopening%2C%20the%20file%20will%20go%20back%20to%20a%20temporary%20view.%26nbsp%3B%20Nothing%20is%20filtered%20on%20my%20end%2C%20it%20just%20looks%20like%20I%20created%20a%20temporary%20view.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%3F%20I%20did%20have%20one%20thought%2C%20would%20Autosave%20cause%20this%20maybe%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2636601%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2642624%22%20slang%3D%22en-US%22%3ERe%3A%20Temporary%20views%20caused%20by%20others%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2642624%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1125997%22%20target%3D%22_blank%22%3E%40mrlee_75%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPower%20Query%3A%3C%2FP%3E%3CP%3EEach%20user%20will%20have%20their%20own%20workbook%20querying%20the%20main%20workbook%20as%20the%20data%20source.%26nbsp%3B%20They%20can%20manipulate%20their%20own%20workbook%20as%20much%20as%20they%20like%20and%20it%20would%20not%20affect%20other%20users%20who%20are%20using%20the%20same%20data%20source.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Echeers%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 in the main default view quite a lot, so I see multiple changes which is no problem.  The issue we are having is that when others turn on one of the sheet views, my default view will become a temporary view for me.  If I hit 'exit' to go back to the default, now I see the sheet view the other person is using.  They say they havent closed the file in the view.  I can remove the filters and close the file to reset the Default view, but a couple of minutes after reopening, the file will go back to a temporary view.  Nothing is filtered on my end, it just looks like I created a temporary view.

 

Any suggestions? I did have one thought, would Autosave cause this maybe?

1 Reply

@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