When she opens up an excel file that her or someone else created on the server it will create the temporary file as normal, but when she closes out of excel the temp file doesnt remove itself. Boots up fine and everything appears to be working OK, except for MS Office 2011.
We have a client using Office for Mac 2011. Hard drive in Macbook Pro was going bad so I cloned it to a new drive using Carbon Copy Cloner. Now, every time you save the file with this macro, you will see the time and date when the file saved in the “A1” cell of “Sheet1”. Get answers from your peers along with millions of IT pros who visit Spiceworks. Double-click to preview your unsaved file, select the right version and click 'Recover' to save the file to another secure location on Mac. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)Ĭopy this code in the “ThisWorkbook” section of your VBA Editor (Read Macro and The Visual Basic Editor to get started with VBA editor if you have not used it before.) and save the file. Click the exact file type - Word, Excel, Powerpoint, Keynote, Pages, Numbers you lost without saving. Thankfully got saved! ? So, to keep track of the latest updated file, I started using following macro: It saves the last time you modified the file by saving the time-stamp in a cell.
#UNDO A SAVE IN EXCELL 2011 FOR MAC HOW TO#
I was working on a workbook which I was modifying continuously. How do you convert Excel to PDF on Mac In this article, we will help you to get acquainted with how to convert excel to PDF on Mac, including the latest macOS 11.
And, sometimes, we end up modifying old file or replacing old file with new ones. We usually keep track of newer files by renaming them with versions or revisions or by looking at the last saved tab in Windows Explorer. This is specially useful for those who work on an excel workbook for weeks and weeks.