Consulting

Results 1 to 6 of 6

Thread: Disable New Excel Auto-save Feature(Not auto recovery)

  1. #1
    VBAX Mentor CBrine's Avatar
    Joined
    Jun 2004
    Location
    Toronto, Canada
    Posts
    387
    Location

    Disable New Excel Auto-save Feature(Not auto recovery)

    I think the new auto save feature in office 365 is a good thing for most users, but I have some concerns about it. I'm wondering if anyone has figured out a method to globally disable it yet? Short sighted on MS's part to not include an easy way to do so, but that's what my research to date is pointing to.

    Thanks in advance
    Cal
    The most difficult errors to resolve are the one's you know you didn't make.


  2. #2
    Moderator VBAX Guru Simon Lloyd's Avatar
    Joined
    Sep 2005
    Location
    UK
    Posts
    3,003
    Location
    In Excel go to File>Options>Advanced> Uncheck "Allow Background Saves" then in the left panel click Save> Uncheck "Keep the last autosaved version if I close without saving” box. But you can't disable it forever, it is only on a per file basis.
    Regards,
    Simon
    Please read this before cross posting!
    In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
    If I have seen further it is by standing on the shoulders of giants.
    Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)

  3. #3
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    In Office 365 you'll find Simon's options under File/Options/Save. Doing this to a blank workbook and then saving it to your XLStart folder as Book should mean new books are created without the Autosave enabled.
    Last edited by mdmackillop; 09-08-2017 at 06:39 AM. Reason: Save as Book1 changed to Save as Book
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  4. #4
    VBAX Mentor CBrine's Avatar
    Joined
    Jun 2004
    Location
    Toronto, Canada
    Posts
    387
    Location
    Thanks for the responses! They might help me out. Still wish MS had at least placed an option to allow you to globally disable this.
    The most difficult errors to resolve are the one's you know you didn't make.


  5. #5
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    Quote Originally Posted by CBrine View Post
    Still wish MS had at least placed an option to allow you to globally disable this.
    We keep telling them that. Can't say whether it will have any effect though.
    Be as you wish to seem

  6. #6
    VBAX Mentor CBrine's Avatar
    Joined
    Jun 2004
    Location
    Toronto, Canada
    Posts
    387
    Location
    I found a solution to this, figured I would post it here.

    https://support.microsoft.com/en-us/...ce-365-proplus

    Looks like you need to actually add an entry to your register, but it does work and turns off the auto-save feature. Make sure you back up your registry first!
    The most difficult errors to resolve are the one's you know you didn't make.


Posting Permissions

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