#EXCEL AUTOSAVE NOT WORKING 2016 CODE#
The only thing I could suspect was I think this started around about the time I installed xlDennis' code library. Some days I can work without this problem, other days I encounter this 2 or 3 times. I can't work out when it goes into this mode. Clicking save just invokes the same msgbox again. If I close the workbook I am prompted to save, close without saving or cancel. Using Save As doesn't either do anything, the dialog is not displayed and if I am doing via the File menu then the File menu is exited and the previous ribbon tab is displayed (i.ethe one I was on before clicking 'File') Found others suffering the same but haven't found any conclusive answer yet.Įvery so often when I attempt to save a file, (including save as), Excel won'r let me. (although I will keep this little piece of magic out of their knowledge so they don't rely on it, just though it would be a secondary back up to helping eliminate these mishaps cause we are loosing alot of information by people saving overtop of other peoples work and not caring.) but a refresh so the screen actually updates in front of you. Secondly as back up I was wondering if you can create a macro to do a refresh of everyones screens automatically - say every 2 or 5 mins? I don't mean a save. instead of them saving by going to File - Save or cntrl+s ? I just thought that MAYBE having a big button in their face will remind them. How to I create a macro button at the top of the page that is literally a SAVE button. It's nothing fancy, just use it as a PO Book but since it is shared some people continue to not save before they add in more work so that they see a "refreshed" copy of the workbook before they start writing in cells that already contain information. We have a "shared" work book we all work in. Here at work, I have some incompentant computer workers who claim they KNOW MS sooo well and have certificates etc. I have been trying to learn macros but have not made one yet.
0 kommentar(er)
