Excel suddenly began saving files on close without prompts - Page 2

Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Excel suddenly began saving files on close without prompts

  1. #11
    Board Regular
    Join Date
    Apr 2012
    Location
    Texas, USA
    Posts
    515
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel suddenly began saving files on close without prompts

     
    I didn't realize there was that property for workbooks. I suppose you'd change it in all workbooks the same way you did in that one.

  2. #12
    New Member
    Join Date
    Dec 2017
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel suddenly began saving files on close without prompts

    It seems MS recently "fixed" a problem with Office 365 that did not set autosave to "on" for cloud-stored files. The fix defaults the setting to "on" and there is no way to turn it off globally - it has to be turned off for each workbook, though once turned off it will remember that setting for that file. There's a little button on the upper right of the Excel window's page to turn on or off the "auto save" feature. VBE is not needed. This solves the problem. The autoupdatefrequency value seems to be unrelated and applies only to the auto recovery feature, that is independent of the auto save feature.

    And, no. autoupdatefreq rejects 5, 1, 10 and a few other values I tried as "invalid property values".

    Thanks for your help.

  3. #13
    New Member
    Join Date
    Dec 2017
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel suddenly began saving files on close without prompts

      
    Neither did I until this afternoon.

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com