Results 1 to 13 of 13
  1. #1


    Member Since
    Jul 08, 2013
    Posts
    11
    Excel "Document not saved" message
    I cannot save my excel spreadsheet because this message comes up every time. I have tried a different name for the workbook several times but I always get the message. I have tried Excel Help but the search for this error message produced nothing. Any suggestions please?
    Thanks

  2. #2

    Slydude's Avatar
    Member Since
    Nov 15, 2009
    Location
    North Louisiana, USA
    Posts
    9,596
    Specs:
    2.8 GHz MacBook Pro 10.11, 8 GB mem, iPhone 6+
    I have not encountered this problem yet with Excel but I did a bit of poking around. Here are the fixes that other users have reported.

    1. Make sure you are running the current version of Excel. That seems to have fixed things for some users.
    2. Repair permissions on the drive using Disk Utility.
    3. Choose Save As and save the file. Some users have also suggested that with this method you must also choose a different file format such as Excel '97. This can cause some loss of formatting etc. if you have used a feature not present in the older file formats.
    Sylvester Roque Former Contributing Editor About This Particular Macintosh

    "Got Time to breathe. You got time for music." Denver Pyle as Briscoe Darling

  3. #3


    Member Since
    Jul 08, 2013
    Posts
    11
    Document not saved message
    Thank you but:
    The machine is only about 4 weeks old, it is Mountain Lion and I understand that supports latest updates.
    Repair permissions did not work although there were some issues in the report - not that I understand what they meant
    I have saved as a different name in Excel 97-2004 and can only wait to find out what features and formatting will not work.
    Meanwhile I will have to keep the .xlsx open all the time until I know.
    Thanks again.

  4. #4

    Slydude's Avatar
    Member Since
    Nov 15, 2009
    Location
    North Louisiana, USA
    Posts
    9,596
    Specs:
    2.8 GHz MacBook Pro 10.11, 8 GB mem, iPhone 6+
    Yes the latest updates are supported for Mountain Lion with that machine. But this is referring to having the most recent version of Excel. It will run on your machine but may or may not already be installed depending upon how recently Excel was installed. I think they released a minor update within the last few weeks.

    The jury seems to be out on how well these steps fix the problem. It is entirely possible that you are experiencing a bug in Excel.

    There are several permissions errors that occur regularly and can safely be ignored unless you are experiencing issues with other programs.
    Sylvester Roque Former Contributing Editor About This Particular Macintosh

    "Got Time to breathe. You got time for music." Denver Pyle as Briscoe Darling

  5. #5

    MacInWin's Avatar
    Member Since
    Jul 07, 2008
    Location
    Winchester, VA
    Posts
    5,603
    Specs:
    2011 MBP, 2008 iMac, iPhone 6, iPad mini, 13" MBP, AppleTV and two MacMinis
    Just out of curiosity, have you looked to see if the file is actually there, and that the error is from Excel wrongly saying it didn't save it? When/If you update Excel, it will close to update the files, so the .xlsx file will be closed at that time, so pretty much at this point, either the file is there, and you can close Excel, or it isn't, but to get an update to Excel, you'd have to close it and lose the file. Tough choices.

  6. #6

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    6,112
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    Copy and paste the contents of this file to Text Edit or another text program in case you lose it. At least then you'll be able to reconstruct it.

  7. #7


    Member Since
    Dec 05, 2013
    Posts
    1
    Excel "Document not saved" message
    move or copy each sheet you have to a new book and save. it works for me.

  8. #8


    Member Since
    Aug 04, 2014
    Posts
    2
    "file not saved" error message in Excel
    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!

  9. #9


    Member Since
    Aug 04, 2014
    Posts
    2
    Follow up to "file not saved" error
    As a follow up to my previous post, this morning I updated Excel, opened a series of different workbooks and one came back with a "file not saved" error message. So consistent updating doesn't always work. I've also found that when the file is not saved, the macros are all blown away in that file and if you continue to work with the corrupted file, the auto save function fails. I continue to rely on my backups but this is becoming a serious issue that Microsoft has yet to address adequately. I'm beginning to suspect it may have something to do with the macro functions since files where I have deleted the macros or don't have macros to begin with don't suffer the "file not saved" error.

    Quote Originally Posted by petroni912 View Post
    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!

  10. #10

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Fort Worth, Texas
    Posts
    48,038
    Specs:
    Late 2013 27" iMac, iPad 3, iPhone 6s+, iPhone 6+, 3 iPods, El Capitan
    I'm not an Excel user, however, macros have been improved in the newer Office 2016 version. There may be reasons why you would not want to upgrade to the newer version but I just thought I would mention that. I have Office 2016 along with Office 2011 but still prefer to use Office 2011 at least until Microsoft makes some needed improvements.

  11. #11


    Member Since
    Apr 16, 2016
    Location
    CT
    Posts
    178
    Specs:
    MacBook Air Mid-2012 / iMac Retina 5K Late-2014
    Where did the original workbook / file come from? How are you opening? The devil is always in the details...
    Thank You to all of the members of the US Armed Forces!

    Never have a battle of wits with an unarmed person. ~Mark Twain

  12. #12

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    6,112
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    Original post is from 2013

  13. #13


    Member Since
    Apr 16, 2016
    Location
    CT
    Posts
    178
    Specs:
    MacBook Air Mid-2012 / iMac Retina 5K Late-2014
    Sigh.

    I'm usually pretty good about not getting caught in that trap.
    Thank You to all of the members of the US Armed Forces!

    Never have a battle of wits with an unarmed person. ~Mark Twain

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 07-07-2014, 06:17 PM
  2. Excel "Document not saved" message
    By Makala in forum OS X - Operating System
    Replies: 8
    Last Post: 12-14-2013, 02:10 PM
  3. Saved text in "Preview" unreadable
    By firefox40 in forum OS X - Apps and Games
    Replies: 1
    Last Post: 09-17-2012, 02:48 PM
  4. Can't delete (or move) Pages "saved versions"
    By yeahcapes in forum Switcher Hangout
    Replies: 2
    Last Post: 09-07-2011, 06:43 PM
  5. iPod Touch "saved photo" problem
    By JMC2008 in forum iOS and Apps
    Replies: 2
    Last Post: 04-17-2009, 06:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •