• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to immediate save excel file automatically

Excel Peppy

Excel Peppy

New Member
So two questions specifically:
1.How to immediate save excel file automatically ? Just like the way google sheet and doc do----we don't need to hit save button every time to save it in case the there is a power outage...who knows?
2. How to automatically save the file when exit? You know how annoying it keeps asking you do you want to save it? Yes, otherwise why do I need to make change on that. So can we skip the question and whenever we close the sheet, it automatically gets saved？I know sometimes I have thick fingers and click No and holly...And I don't want this feature just for one sheet, but for every excel file. I see some VBA stuff, but they are only for single sheet.

Thanks!
Excel Peppy
 
auto save can only save after 1 min right? And if I accidentally hit not save when I exit, then I need to find the recovery copy somewhere. Yeah I am a dummy sometimes, just trying to see besides auto save, is there any way better?
 
I use Ctrl+S regularly

But as Nebu mentioned set the Auto Recover time to 1 min if your really concerned

Goto File, Options, Save:

upload_2014-11-21_12-3-45.png
 
You must log in or register to reply here.
Back
Top