Problems with Autosave Function in Excel 2010?

Question

At the moment I have several work PC's (Windows 7) connected via a Network. The same Excel document can be opened from the same file location by several different systems (PC's) at the same time and shared, thus allowing whatever changes that are made on each system to be saved to the file location which in turn keeps every system updated with any changes.

The problem I have is that this only seems to work when the user manually clicks the save button. I wish to enable the autosave feature on each system to replicate what I have at the moment and autosave all changes by all users to the workbook every few minutes so that the workbook is constantly updated.

Please don't post me instructions of how this function works in older versions of Excel or how to turn the autosave function on as I know how to do this. However, this does not work as the autosave does not save the updated file to the original location and overwrite the file like a standard save... Which is what i need it to do!

Any help will be greatly appreciated!

Many Thanks

John

Answer 1

Edit: then the alternative is to create an 'on-time' macro to replicate clicking the 'Save' button. Try the following method.



Copy the following event handler to the clipboard:



Private Sub Workbook_Open()

CallSave

End Sub



Press ALT + F11



Double click 'This Workbook' in the Microsoft Excel VBA Project properties in the upper left quadrant.



Paste the event handler into the editing area to the right and close the VBE.



Still in the VBE, select INSERT > MODULE in the menu options at the top.



Copy the following two macros to the clipboard:



Sub CallSave()

Application.OnTime Now + TimeValue("00:03:00"), "SaveIt"

End Sub



Sub SaveIt()

Application.DisplayAlerts = False

ActiveWorkbook.Save

CallSave

End Sub



Paste them into the newly created Module.



Close the VBE and return to the worksheet. Save the workbook.



Now, each time the workbook is opened, it will trigger the CallSave macro. After 3 minutes elapse, that macro will call the SaveIt macro which saves the workbook without prompting the user. After saving it calls the CallSave macro again. After 3 more minutes the workbook will be saved again. This loop will repeat as long as the workbook is open.



Change the ("00:03:00") element to whatever timing cycle you wish, i.e. ("00:05:00") would be a 5 minute cycle.



Advise if additional assistance is needed.



========================

















The 'AutoSave' function in Excel 2010 has morphed into the AutoRecover function, located in the File > Options > Save settings.



In those settings you have the ability to set the 'save to' file location. Assuming you are on a server, you should be able to direct the save function to a server drive.



Without the ability to fully test this, I would suggest trying the following WorkBook_Open event handler. Change the timing cycle to whatever you wish. This sets it at 5 minutes.



Copy the following code to the clipboard:



Private Sub Workbook_Open()

With Application.AutoRecover

.Enabled = True

.Time = 5

End With

ActiveWorkbook.EnableAutoRecover = True

End Sub



Press ALT + F11



Double click 'This Workbook' in the Microsoft Excel VBA Project properties in the upper left quadrant.



Paste the event handler into the editing area to the right and close the VBE.



Save the workbook.

Answer 2

Excel 2010 Autosave Not Working

Answer 3

Most people just can not manage to help keep losing and dropping and losing until the income is all gone. And alongside it move your home, your loved ones and you regard but with Zcodes System from here https://tr.im/B2nkT this is simply not going to happen.

With Zcodes System you will have an computerized method doing all that work for you in the background and then formulating probably the most probably outcome, you can use that information and choose the absolute most likely earning staff a whole lot more correctly than the typical Joe.

Zcodes suggests that you follow the A-B-C betting technique.  That's, make a 1-unit bet.  If you eliminate, produce a 2-unit bet.  If you eliminate that, create a 3-unit bet.  In the event that you lost that, reset and start back along with your “A” bet. By using this A-B-C technique, you must come forward about 86.5% of that time period with each A-B-C line you perform applying Zcodes, pretty good odds.

Answer 4

Game betting can be enjoyment to accomplish but with this system https://tr.im/UPiVR , Zcodes System you may also have a great addition to make some added money.

The great thing about the Zcodes System is that even though you never seen a basketball or a tennis game in your lifetime, you are able to follow the system's winning picks and generate income from activities you're maybe not compelled to watch, obviously seeing the specific games you're betting on can be quite a enjoyment task but recall a tennis game may last around 4-5 hours in some cases, the equivalent of watching “The Master of the Rings”…

Using Z Signal System is similar to having your personal specialized staff of activities handicappers working often for you personally every day!

Answer 5

Can you not set up the auto save through the options like you can in word?

Options save-select the time and location of auto recovery{save}

Hope this is what you're looking for

Answer 6

2

Answer 7

1