Saving Excel file to Network drive

[kantjer]

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]

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

 

[kantjer]

Thanks Gord that solved my problem.

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

 

[Gord Dibben]

Excellent.

Thanks for the feedback.

Gord

Thanks Gord that solved my problem.

 

[Harlan Grove]

Gord Dibben wrote...

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

....

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.

 

[Amedee Van Gasse]

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

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.deBoynePollard/FGA/questions-with-yes-or-n
o-answers.html