Saving Excel file to Network drive

I recently bought a Buffalo network drive so I can access my files from both
my laptop and desktop. This works perfect for my Word documents and even my
Outlook PST. The problem is when I try to save an Excel (2003) file to the
network drive I get a message like



File xxx.Xls is possibly changed by an other user since you last saved it,
do you want to overwrite it or to save with another name.



(My Office version is not in English so this is my translation of the
message)



This only happens if I open an existing file, it happens even after I try to
save it immediately after opening. I can overwrite it so the file is not
locked (what would surprise me because there nobody else on the network)

It happens when saving files on both desktop or laptop.



The only way I found so bypass this message is to make every workbook shared
but that way I loos functionality.



I there a way to be able to save Excel files to a network drive without make
the Work book shared?



Thanks



PS. I'm using Win Xp Pro on Desktop and laptop

Have a look at this KB Article

"The file may have been changed..." error when you save workÂ*book to network
server in Excel 2002

http://support.microsoft.com/default.aspx?kbid=324491

Myrna Larson also reported that she got this error when opening a workspace
(*.xlw) file.

Opening the workbooks individually solved the problem.


Gord Dibben Excel MVP

On Tue, 5 Apr 2005 16:33:39 +0200, "kantjer" <[email protected]> wrote:

>
>
>
>
>I recently bought a Buffalo network drive so I can access my files from both
>my laptop and desktop. This works perfect for my Word documents and even my
>Outlook PST. The problem is when I try to save an Excel (2003) file to the
>network drive I get a message like
>
>
>
>File xxx.Xls is possibly changed by an other user since you last saved it,
>do you want to overwrite it or to save with another name.
>
>
>
>(My Office version is not in English so this is my translation of the
>message)
>
>
>
>This only happens if I open an existing file, it happens even after I try to
>save it immediately after opening. I can overwrite it so the file is not
>locked (what would surprise me because there nobody else on the network)
>
>It happens when saving files on both desktop or laptop.
>
>
>
>The only way I found so bypass this message is to make every workbook shared
>but that way I loos functionality.
>
>
>
>I there a way to be able to save Excel files to a network drive without make
>the Work book shared?
>
>
>
>Thanks
>
>
>
>PS. I'm using Win Xp Pro on Desktop and laptop
>
>
>

Thanks Gord that solved my problem.

"Gord Dibben" <gorddibbATshawDOTca> schreef in bericht
news:[email protected]...
> Have a look at this KB Article
>
> "The file may have been changed..." error when you save workÂ*book to
> network
> server in Excel 2002
>
> http://support.microsoft.com/default.aspx?kbid=324491
>
> Myrna Larson also reported that she got this error when opening a
> workspace
> (*.xlw) file.
>
> Opening the workbooks individually solved the problem.
>
>
> Gord Dibben Excel MVP
>
> On Tue, 5 Apr 2005 16:33:39 +0200, "kantjer" <[email protected]> wrote:
>
>>
>>
>>
>>
>>I recently bought a Buffalo network drive so I can access my files from
>>both
>>my laptop and desktop. This works perfect for my Word documents and even
>>my
>>Outlook PST. The problem is when I try to save an Excel (2003) file to the
>>network drive I get a message like
>>
>>
>>
>>File xxx.Xls is possibly changed by an other user since you last saved it,
>>do you want to overwrite it or to save with another name.
>>
>>
>>
>>(My Office version is not in English so this is my translation of the
>>message)
>>
>>
>>
>>This only happens if I open an existing file, it happens even after I try
>>to
>>save it immediately after opening. I can overwrite it so the file is not
>>locked (what would surprise me because there nobody else on the network)
>>
>>It happens when saving files on both desktop or laptop.
>>
>>
>>
>>The only way I found so bypass this message is to make every workbook
>>shared
>>but that way I loos functionality.
>>
>>
>>
>>I there a way to be able to save Excel files to a network drive without
>>make
>>the Work book shared?
>>
>>
>>
>>Thanks
>>
>>
>>
>>PS. I'm using Win Xp Pro on Desktop and laptop
>>
>>
>>
>

Excellent.

Thanks for the feedback.

Gord

On Tue, 5 Apr 2005 18:09:16 +0200, "kantjer" <[email protected]> wrote:

>Thanks Gord that solved my problem.
>
>"Gord Dibben" <gorddibbATshawDOTca> schreef in bericht
>news:[email protected]...
>> Have a look at this KB Article
>>
>> "The file may have been changed..." error when you save workÂ*book to
>> network
>> server in Excel 2002
>>
>> http://support.microsoft.com/default.aspx?kbid=324491
>>
>> Myrna Larson also reported that she got this error when opening a
>> workspace
>> (*.xlw) file.
>>
>> Opening the workbooks individually solved the problem.
>>
>>
>> Gord Dibben Excel MVP
>>
>> On Tue, 5 Apr 2005 16:33:39 +0200, "kantjer" <[email protected]> wrote:
>>
>>>
>>>
>>>
>>>
>>>I recently bought a Buffalo network drive so I can access my files from
>>>both
>>>my laptop and desktop. This works perfect for my Word documents and even
>>>my
>>>Outlook PST. The problem is when I try to save an Excel (2003) file to the
>>>network drive I get a message like
>>>
>>>
>>>
>>>File xxx.Xls is possibly changed by an other user since you last saved it,
>>>do you want to overwrite it or to save with another name.
>>>
>>>
>>>
>>>(My Office version is not in English so this is my translation of the
>>>message)
>>>
>>>
>>>
>>>This only happens if I open an existing file, it happens even after I try
>>>to
>>>save it immediately after opening. I can overwrite it so the file is not
>>>locked (what would surprise me because there nobody else on the network)
>>>
>>>It happens when saving files on both desktop or laptop.
>>>
>>>
>>>
>>>The only way I found so bypass this message is to make every workbook
>>>shared
>>>but that way I loos functionality.
>>>
>>>
>>>
>>>I there a way to be able to save Excel files to a network drive without
>>>make
>>>the Work book shared?
>>>
>>>
>>>
>>>Thanks
>>>
>>>
>>>
>>>PS. I'm using Win Xp Pro on Desktop and laptop
>>>
>>>
>>>
>>
>

Gord Dibben wrote...
>Have a look at this KB Article
>
>"The file may have been changed..." error when you save work=ADbook to
network
>server in Excel 2002
>
>http://support.microsoft.com/default.aspx?kbid=3D324491
..=2E.

Useful information, but one is left wondering why isn't
QFE_Saskatchewan set to 2 Excel 2002/2003's *DEFAULT* behavior?!
Programmers and DBAs have know for decades that they needed to flush
buffers (or sync on Unix/Linux/BSD systems) to ensure robust
transaction and file control.

The cynic in me is tempted to believe that Microsoft gave Excel default
no-wait/no-flush behavior in order to improve benchmark timing results.

Harlan Grove shared this with us in microsoft.public.excel:

> Programmers and DBAs have know for decades that they needed to flush
> buffers (or sync on Unix/Linux/BSD systems)

Eat my sig cookie ;-)

> to ensure robust transaction and file control.
>
> The cynic in me is tempted to believe that Microsoft gave Excel
> default no-wait/no-flush behavior in order to improve benchmark
> timing results.

You're not cynical, you're a keen observer.
And it's not only Excel.

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way
http://www.catb.org/~esr/faqs/smart-questions.html
How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoyn...-with-yes-or-n
o-answers.html