Reply to thread

Message

<blockquote data-quote="petroni912" data-source="post: 1597210" data-attributes="member: 330444">&quot;file not saved&quot; error message in ExcelFrom my own experience using Office 2011. If you encounter this error in Excel, the file is corrupted. Your macros disappear and the file cannot be saved. Unsaved data up to this point will be lost if you close the file. To avoid having this happen, update both Mac OS and Office software consistently.&nbsp; I find that when I skip a few months, the problem resurfaces.Always &quot;test&quot; save your file when you first open it to make sure it isn't corrupted. That way you won't lose any data when you do get the error message. If you do get a &quot;file not saved&quot; error, close the file and update both Mac and Office software. Open the corrupted file and select/copy all the data. Retrieve an old backup copy (you do have backups!) and paste in the current data from the corrupted file. Save the backup file with the new data, close and discard the corrupted file and make sure the new file has correct dates, macros and the file name matches the old corrupted file so any links to other spread sheets still work.I know it's a pain in the butt, however it works for me, I just had to go through the routine again this morning since I got remiss in updating the OS and Office file. I got it down to a science now so that the one or two times it happens a year, I only lose about a half hour of work timeCheers!</blockquote>

[QUOTE="petroni912, post: 1597210, member: 330444"] [b]"file not saved" error message in Excel[/b] From my own experience using Office 2011. If you encounter this error in Excel, the file is corrupted. Your macros disappear and the file cannot be saved. Unsaved data up to this point will be lost if you close the file. To avoid having this happen, update both Mac OS and Office software consistently. I find that when I skip a few months, the problem resurfaces. Always "test" save your file when you first open it to make sure it isn't corrupted. That way you won't lose any data when you do get the error message. If you do get a "file not saved" error, close the file and update both Mac and Office software. Open the corrupted file and select/copy all the data. Retrieve an old backup copy (you do have backups!) and paste in the current data from the corrupted file. Save the backup file with the new data, close and discard the corrupted file and make sure the new file has correct dates, macros and the file name matches the old corrupted file so any links to other spread sheets still work. I know it's a pain in the butt, however it works for me, I just had to go through the routine again this morning since I got remiss in updating the OS and Office file. I got it down to a science now so that the one or two times it happens a year, I only lose about a half hour of work time Cheers! [/QUOTE]

Verification

Name this item 🌈