How to disable all forms of autosave for a certain workbook.

[Harvey]

Hi all,

I have ths problem:

Intro
I made an excel application that stores its data on the worksheet. When a user clicks save the data is exported to an xml-file. The application xls changes in the process, so excel tries to auto(save) it. I cannot have this happening. I do not want any messages pop up (this file is read only or cannot save), so I want to completely disable all kinds of autosave and autorecovery events.

Question
Can someone explain to me what autosave processes run during excel, and how to disable them. Note that other documents should autosave properly, even if they are opened at the same time as my workbook.

Other suggestions are welcome too, thanks in advance for any replies.

 

[Harvey]

help me please, I have searched an read other topics but I'm not sure of how to turn it all off.

 

[Harvey]

is there noone that can answer my question?

 

[agihcam]

not sure what you're looking for. disable autosave from;
tools > add-ins > untick auto save add in

 

[jindon]

Not sure

If you are writing the code to Workbook_BeforeSave event

Cancel = True

is the code for not save.

 

[Harvey]

thanks.

unfortunately, this does not cover everything. There seems to be some other autosave/autobackup procedure that I think I have to cancel too.
But I am not completely sure of how to do it and I don't exactly know what it really does either.

Do you know more about this one?

thanks for the help so far.

 

[jindon]

Re: How to disable all forms of autosave for a certain workb

Hi all,

I have ths problem:

Intro
I made an excel application that stores its data on the worksheet. When a user clicks save the data is exported to an xml-file. The application xls changes in the process, so excel tries to auto(save) it. I cannot have this happening. I do not want any messages pop up (this file is read only or cannot save), so I want to completely disable all kinds of autosave and autorecovery events.

I cannot think of any other than BeforeSave event for this action.

Or are you calling Sub procedure in the BeforeSave event code?

 

[Harvey]

Hmm I can't find an article related to this right now, but what I mean is this:

If Excel crashes when you are working in it, and you restart, Excel has made some kind of backup file to restore your workbooks.

I want this function to be either disabled for my workbook or disabled as long as the workbook is open, preferably the first option.

 

[erik.van.geit]

Hi,

in the menu tools / options: TAB "Save" you can switch on and off this option

    ActiveWorkbook.EnableAutoRecover = False

it is workbookspecific which means you can put it to False for one workbook, while still having it running for the others (that's how I understand my experiments)

kind regards,
Erik

 

[Harvey]

Hi,

Thanks Eric. This is what I needed.

Can you tell me if this two measures are enough to prevent auto saving of the workbook? The user itself can save it but that's no problem for me.