software

Is there a way to configure excel to actuall modify a spreadsheet that it is
editing, as opposed to makeing a temporary copy of the file, and overwriting
the edited file with a new file?

Not that I ever heard of.

Filegt;Save As a new name will not overwrite the original, but also the original
will not have the edting changes.

What are you looking to do?Gord Dibben Excel MVPOn Tue, 13 Dec 2005 11:50:02 -0800, quot;A Samonquot; lt;A
gt; wrote:

gt;Is there a way to configure excel to actuall modify a spreadsheet that it is
gt;editing, as opposed to makeing a temporary copy of the file, and overwriting
gt;the edited file with a new file?

I don't quite understand what you are asking - if you SAVE the file as
you work on it it will overwrite the original.

PeteI currently have several thousand excel spreadsheets arranged in a
hierarchial directory structure on a novell 6.5 server with hardlinks
enabled. I have created a directory that has a hardlink to each spreadsheet
in my directory structure. quot;hardlinks are way of createing a type of
shortcut where the two files actually occupy the same inodequot; The problem is
that a hardlink can be deleted, so when excel overwrites the file It
effectivel breaks the hardlink, and now I have two files that are not the
same. If excel could be configured to open/edit/save rather than open/create
temporary copy/modify copy/overwrite original I would be in business. Thanks

quot;Gord Dibbenquot; wrote:

gt; Not that I ever heard of.
gt;
gt; Filegt;Save As a new name will not overwrite the original, but also the original
gt; will not have the edting changes.
gt;
gt; What are you looking to do?
gt;
gt;
gt; Gord Dibben Excel MVP
gt;
gt;
gt; On Tue, 13 Dec 2005 11:50:02 -0800, quot;A Samonquot; lt;A
gt; gt; wrote:
gt;
gt; gt;Is there a way to configure excel to actuall modify a spreadsheet that it is
gt; gt;editing, as opposed to makeing a temporary copy of the file, and overwriting
gt; gt;the edited file with a new file?
gt;