Results 1 to 9 of 9
  1. #1


    Member Since
    Jun 18, 2017
    Posts
    5
    Office 2011 for Mac - Excel autosave problems
    Hi

    I have Microsoft Office for Mac 2011 and have started having a problem with the autosave function for Excel documents. I have the preferences set to autosave after a few minutes each excel document but am finding that some ( not all ) excel documents are asking me to save them ( when left open in the bottom bar of the Imac ) on closing down the computer. It is strange as some documents never ask to be saved and autosave seems to function perfectly. Others ask to be saved on close down every day.

    Has anyone had this problem too and found a solution?

  2. #2

    Sawday's Avatar
    Member Since
    Nov 19, 2006
    Location
    York, UK
    Posts
    1,428
    Specs:
    iMac: 24" Aluminium, 2.8 GHz, 4Gb RAM. iPad2, iPad mini2, iPhone5s
    Are the ones that ask to be saved ones that you have edited since the autosave by chance?
    Experience teaches you to recognise a mistake when you make it again.

  3. #3


    Member Since
    Jun 18, 2017
    Posts
    5
    No because I normally save each document before putting it down on the bottom bar.

  4. #4

    Slydude's Avatar
    Member Since
    Nov 15, 2009
    Location
    North Louisiana, USA
    Posts
    12,157
    Specs:
    2.8 GHz MacBook Pro 10.11, 8 GB mem, iPhone 6+, 2015 iMac
    Are the documents in question based on a template? Originally created as an Excel template? I think that format asks you to save any time the document is closed.
    "Got Time to breathe. You got time for music." Denver Pyle as Briscoe Darling

  5. #5

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Keller, Texas
    Posts
    53,249
    Specs:
    Late 2013 27" iMac, 10.5" iPad Pro, iPhone 6s+, iPhone 7+, Numerous iPods, Sierra
    Known problem with Office 2011. Autosave is broken and has been broken ever since Microsoft deployed Office 2011. Do not depend on autosave for Word, Excel, or Powerpoint. Save your documents often and make sure that you choose "Always make a backup" in Office 2011 preferences. You can read more about the broken autosave function by going to the Microsoft Office forums. The autosave function in Office 2016, Office 365 should work better.

  6. #6

    Slydude's Avatar
    Member Since
    Nov 15, 2009
    Location
    North Louisiana, USA
    Posts
    12,157
    Specs:
    2.8 GHz MacBook Pro 10.11, 8 GB mem, iPhone 6+, 2015 iMac
    Thanks for that reminder Charlie. Not sure if I never knew that or had forgotten it. I've never really liked depending upon any program's autosave feature for anything important.

    BTW Suppose someone creates a new document and does the initial save. They then continue to work on the document but have not done a second save (manually or by autosave). If a time machine backup occurs does it have just the saved version of the file or does it have the info from the open file? I think it would have the saved version only and none of the info since the file was last saved.
    "Got Time to breathe. You got time for music." Denver Pyle as Briscoe Darling

  7. #7

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Keller, Texas
    Posts
    53,249
    Specs:
    Late 2013 27" iMac, 10.5" iPad Pro, iPhone 6s+, iPhone 7+, Numerous iPods, Sierra
    I don't think Time Machine can save an open file (maybe it can) so I would think that the last time the file was saved is what it will save. However, if you choose "always make a backup" from Office preferences, then every time the file is accessed it will be backed up and saved. Just make sure you direct the backup saves to a place where you can find them. I have mine going to the "Documents" folder. This is what it looks like:

    "Backup of Father's Day.docx"

    Every time I edit the file, (Father's Day.docx) a new backup version of it will be saved over the top of the previous one. That is the only thing that works right with the autosave function in Office 2011.

  8. #8


    Member Since
    Jun 18, 2017
    Posts
    5
    Thank you to you all for your informative replies to mu inquiry. I will take them all onboard. I have to say its the illogical thing about it happening with some but not all excel documents which puzzles me most. I do normally save each document before reducing it to the bar and yet they still need to be saved again on closing down the imac.

  9. #9

    harryb2448's Avatar
    Member Since
    Nov 28, 2007
    Location
    Nambucca Heads Australia
    Posts
    24,265
    Specs:
    iMac, i7 4GHz, 32GB memory, 1TB Flash Storage, OS X.12.6.
    Is Office 2011 up to date, current version is 14.7.5?
    Hang on to those original install discs like grim death! Using OS X.7 or later make a bootable USB thumb drive before running Installer!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MS Office 2011 for Mac Excel Problem
    By bcviking in forum macOS - Apps and Games
    Replies: 4
    Last Post: 04-27-2016, 06:59 PM
  2. lost excel menu in office for mac 2011
    By azdadsun in forum macOS - Operating System
    Replies: 0
    Last Post: 06-03-2014, 02:00 PM
  3. MS Office 2011 for Mac - Excel ->Memory
    By fak119 in forum macOS - Apps and Games
    Replies: 8
    Last Post: 04-15-2013, 10:42 PM
  4. Word for Mac 2011 autosave fails
    By joh0369 in forum macOS - Apps and Games
    Replies: 9
    Last Post: 02-25-2013, 10:57 PM
  5. AutoSave(?) is IRRITATING!! - MS Office for Mac
    By lorimomof4 in forum macOS - Apps and Games
    Replies: 7
    Last Post: 02-02-2011, 06:22 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
  •