#1   Report Post  
Wayne Gore
 
Posts: n/a
Default Autosave path

Hi

I've set up a share on our server where our users can save and modify excel
sheets. They don't have any permissions to delete any documents however.
This works just fine except from one little detail.
The autosave feature can't delete it's file when the application is closed
so I end up with a ton of small autosave files in this share.

How can I redirect the path where the autosave feature saves the data?

Regards
Wayne

  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Wayne

Which version of Excel are you running?

There is no Autosave in XL2002 and 2003 as there was in earlier versions.

Autorecovery from ToolsOptionsSave is it. This is not the same as Autosave
which made true incremental saves at intervals.

Autorecovery just saves temporary files which should be deleted if Excel
closes normally without incident.

The default folder for Autorecovery can be changed under ToolsOptionsSave.

If you're running XL 2000 or older the AutoSave folder cannot be changed
AFAIK.

Jan Karel Pieterse has an addin called AutoSafe.

It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or
puts them in the recycle bin). And the user can always restore the backups
from the recycle bin.

http://www.jkp-ads.com/Download.htm

(look for AutoSafe.zip)

Gord Dibben Excel MVP

On Mon, 31 Jan 2005 02:25:02 -0800, "Wayne Gore"
wrote:

Hi

I've set up a share on our server where our users can save and modify excel
sheets. They don't have any permissions to delete any documents however.
This works just fine except from one little detail.
The autosave feature can't delete it's file when the application is closed
so I end up with a ton of small autosave files in this share.

How can I redirect the path where the autosave feature saves the data?

Regards
Wayne


  #3   Report Post  
Wayne Gore
 
Posts: n/a
Default

Hi Gord

Thank you for your answer.
I'm using Excel 2000 so I guess I have to look for 3rd party solutions.

Surprising that MS don't make it better than that...

Again, thanks for your help.

Wayne


"Gord Dibben" wrote:

Wayne

Which version of Excel are you running?

There is no Autosave in XL2002 and 2003 as there was in earlier versions.

Autorecovery from ToolsOptionsSave is it. This is not the same as Autosave
which made true incremental saves at intervals.

Autorecovery just saves temporary files which should be deleted if Excel
closes normally without incident.

The default folder for Autorecovery can be changed under ToolsOptionsSave.

If you're running XL 2000 or older the AutoSave folder cannot be changed
AFAIK.

Jan Karel Pieterse has an addin called AutoSafe.

It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or
puts them in the recycle bin). And the user can always restore the backups
from the recycle bin.

http://www.jkp-ads.com/Download.htm

(look for AutoSafe.zip)

Gord Dibben Excel MVP

On Mon, 31 Jan 2005 02:25:02 -0800, "Wayne Gore"
wrote:

Hi

I've set up a share on our server where our users can save and modify excel
sheets. They don't have any permissions to delete any documents however.
This works just fine except from one little detail.
The autosave feature can't delete it's file when the application is closed
so I end up with a ton of small autosave files in this share.

How can I redirect the path where the autosave feature saves the data?

Regards
Wayne



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link path not updating when renamed Ausrobbo Excel Discussion (Misc queries) 0 January 17th 05 10:21 AM
How to change the Excel Title Bar to show the full file path na... lmilkey8855 Excel Discussion (Misc queries) 2 January 6th 05 04:08 PM
How do link to a remote worksheet using the path value in a field? Michael T. Links and Linking in Excel 3 December 11th 04 09:45 AM
How do link to a remote field but use the path from a stored field Michael T. Excel Discussion (Misc queries) 1 December 10th 04 01:18 AM
Entering Path Name in Footer Emily Edgington Excel Worksheet Functions 2 November 9th 04 07:48 PM


All times are GMT +1. The time now is 01:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"