AutoSave

energizer68usa · Mar 29th, 2002, 02:42 PM

In the Office 97 version of Excel, when you selected "AutoSave" from the Tools menu and deselected "prompt before saving," Excel remembered this selection every time you opened the program, even after you re-boot. In the Office 2000 version, Excel remembers the "AutoSave" selection, but you have to go in each time you reopen the program and deselect "prompt before saving" all over again. This gets very annoying when you are working with more than one spreadsheet at a time and do not want to be prompted everytime it is time to save! Does anyone know of a way to tell Excel that the prompt should be deselected every time the program is opened?

[ This Message was edited by: energizer68usa on 2002-03-29 13:43 ]

Jack in the UK · Mar 30th, 2002, 02:23 PM

HI

Good question

Anyosave is a nasty little thing that causes all kinds of agros, but we dont want to delve intio them now.

The way Excel save naturally save or save as or ctrl + s are dreadful by programming standards, not tht i can do better but gawd alone knows why we cant have Words way of fast save, not the ruvbbish excel offers.

NO you can in E97 and wont.. can adjust so VBA trips OnTime to save at every 10 mins which is the same but less probmatic.

XP is better but the sane bgs appear. Word i have with passions no reason bar its not excel but Excel i love and she would be sexy witth words save technologys.

Maybe one day!

Mar 30th, 2002, 02:23 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	HI Good question Anyosave is a nasty little thing that causes all kinds of agros, but we dont want to delve intio them now. The way Excel save naturally save or save as or ctrl + s are dreadful by programming standards, not tht i can do better but gawd alone knows why we cant have Words way of fast save, not the ruvbbish excel offers. NO you can in E97 and wont.. can adjust so VBA trips OnTime to save at every 10 mins which is the same but less probmatic. XP is better but the sane bgs appear. Word i have with passions no reason bar its not excel but Excel i love and she would be sexy witth words save technologys. Maybe one day! __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 29th, 2002, 02:42 PM	#1
energizer68usa New Member Join Date: Mar 2002 Posts: 5	In the Office 97 version of Excel, when you selected "AutoSave" from the Tools menu and deselected "prompt before saving," Excel remembered this selection every time you opened the program, even after you re-boot. In the Office 2000 version, Excel remembers the "AutoSave" selection, but you have to go in each time you reopen the program and deselect "prompt before saving" all over again. This gets very annoying when you are working with more than one spreadsheet at a time and do not want to be prompted everytime it is time to save! Does anyone know of a way to tell Excel that the prompt should be deselected every time the program is opened? [ This Message was edited by: energizer68usa on 2002-03-29 13:43 ]