Excel Autosave

%3CLINGO-SUB%20id%3D%22lingo-sub-2560612%22%20slang%3D%22en-US%22%3EExcel%20Autosave%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2560612%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20large%20workbook%20and%20each%20time%20the%20users%20(up-to%2015%20simultaneous%20users)%20move%20the%20cursor%20from%20cell%20to%20cell%20a%20recalc%20is%20performed%20to%20refresh%20(header)%20dates%20displayed%20in%20a%20sheet.%26nbsp%3B%20With%20so%20many%20users%20moving%20around%20the%20workbook%2C%20there%20is%20latency%20due%20to%20all%20of%20the%20%22Autosaves%22%20that%20are%20initiated.%26nbsp%3B%20Hence%2C%20I%20want%20to%20reduce%20the%20number%20of%20autosaves.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20the%20Change%20event%20occurs%20autosave%20should%20be%20initiated.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20disable%20Autosave%20in%20the%20SelectionChange%20event%2C%20which%20is%20where%20the%20header%20date%20is%20calculated%2C%20and%20other%20users%20change%20a%20cell's%20value%2C%20will%20this%20prevent%20the%20data%20other%20users%20entered%20from%20appearing%20in%20my%20workbook%3F%26nbsp%3B%20Do%20I%20have%20any%20chance%20of%20losing%20data%20by%20disabling%20Autosave%20for%20a%20fraction%20of%20a%20second%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3EDavid%20Epstein%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2560612%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2561121%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20Autosave%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2561121%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1106652%22%20target%3D%22_blank%22%3E%40davidepstein22%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3E%3CSPAN%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3CP%3EIf%20you're%20looking%20to%20ask%20a%20question%20or%20start%20a%20conversation%20about%20Excel%2C%20you're%20in%20the%20right%20place!%26nbsp%3B%20Ask%20away.%3C%2FP%3E%3CP%3EPlease%20include%20the%20following%20info%20to%20help%20others%20answer%20your%20question%3A%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSTRONG%3EDevice%20and%20OS%20platform%3C%2FSTRONG%3E%2C%20e.g.%2C%20PC%2FWindows%2010%20(see%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fwindows%2Fwhich-version-of-windows-operating-system-am-i-running-628bec99-476a-2c13-5296-9dd081cdd808%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EWhich%20version%20of%20Windows%20operating%20system%20am%20I%20running%3F%3C%2FA%3E)%20or%20Mac%2FmacOS%20Big%20Sur%2011.2.1%20(see%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20%3CA%20href%3D%22https%3A%2F%2Fsupport.apple.com%2Fen-us%2FHT201260%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EFind%20out%20which%20macOS%20your%20Mac%20is%20using%3C%2FA%3E)%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EExcel%20product%20name%20and%20version%20number%3C%2FSTRONG%3E%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20(see%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fabout-office-what-version-of-office-am-i-using-932788b8-a3ce-44bf-bb09-e334518b8b19%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAbout%20Office%3A%20What%20version%20of%20Office%20am%20I%20using%3F%3C%2FA%3E)%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EExcel%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20file%3C%2FSTRONG%3E%20you're%20working%20with%20or%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20%3CSTRONG%3Esample%20file%20with%20data%3C%2FSTRONG%3E%E2%80%93%20please%20remove%20all%20confidential%20and%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20PII%20data%3C%2FLI%3E%3CLI%3EAs%20much%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20%3CSTRONG%3Econtext%3C%2FSTRONG%3E%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20of%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20%3CSTRONG%3Ewhat%3C%2FSTRONG%3E%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20you're%20trying%20to%20do%20-%20and%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20%3CSTRONG%3Ewhy%3C%2FSTRONG%3E-%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20as%20possible%2C%20e.g.%2C%20how%20what%20you're%20trying%20to%20do%20fits%20into%20what%20larger%20process%20or%20workflow*%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EExpected%20result%3C%2FSTRONG%3E%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20and%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20%3CSTRONG%3Emethod%3C%2FSTRONG%3E%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20to%20achieve%20the%20result**%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EWhere%20is%20the%20file%20stored%3F%3C%2FSTRONG%3E%20sharepoin%2C%20One%20Drive%2C%20NAS%2C%20etc.%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20you%20got%20a%20good%20answer%20to%20your%20question%2C%20please%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20%3CSTRONG%3Eaccept%20it%20as%20solution%3C%2FSTRONG%3Eto%20help%20others%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20looking%20for%20answer%20to%20the%20same%2Fsimilar%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I have a large workbook and each time the users (up-to 15 simultaneous users) move the cursor from cell to cell a recalc is performed to refresh (header) dates displayed in a sheet.  With so many users moving around the workbook, there is latency due to all of the "Autosaves" that are initiated.  Hence, I want to reduce the number of autosaves.

 

When the Change event occurs autosave should be initiated.  

 

If I disable Autosave in the SelectionChange event, which is where the header date is calculated, and other users change a cell's value, will this prevent the data other users entered from appearing in my workbook?  Do I have any chance of losing data by disabling Autosave for a fraction of a second?

 

 

Thanks!

David Epstein

 

 

3 Replies

@davidepstein22 


Welcome to your Excel discussion space!

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!  Ask away.

Please include the following info to help others answer your question:

 

Once you got a good answer to your question, please accept it as solution to help others looking for answer to the same/similar question.

 

 

Thank you for your understanding and patience

 

Nikolino
I know I don't know anything (Socrates)

@NikolinoDE 

 

Windows Version 10.0.19043 Build 19043

Excel - Microsoft Apps for Enterprise MSO 16.0.313801.20442 (32-bit)

The file is saved in OneDrive / SharePoint.  

I do not believe I need to upload a copy of the file, as my question is straightforward.  

 

Appreciate your help,

Dave

 

@davidepstein22 

I am certainly not the most suitable in this area to help you, my knowledge in this area is very limited. However, with your permission, I will send you some information on this subject with possible approaches.

 

What IT administrators should know about AutoSave

AutoSave can be configured the following ways: for more Informations click on the Microsoft Link.

 

What is AutoSave?

Here are some frequently asked questions about it.

 

Hope I was able to help you with this information.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here