Sharing excel file over local area network

[Ravi Verma]

Hi,

I have four computers in office all connected in a local area network. I
have an excel file on one of the computers and all other 3 computer users
and also the computer containing the main excel file are being used at the
same time, when someone clicks on save button on their respective pc the
main file gets updated. everything was going smoothly for some days, but of
late I am facing a new problem.
When some one opens the file or clicks on save button the original file gets
renamed automatically and the association with excel loses, the icon changes
also. It gets renamed to something like E0094, etc.

I have no clue what is happening, I would also like to add that some days it
works fine.
Is there any problem in accessing the file from network places? I have saved
the main file on one of the pc's d drive, which is full shared.

My os is windows xp and i m using microsoft office xp. Kindly let me know
how to solve the problem and also tell me what is the best way of sharing an
excel file over a peer to peer network.

Regards,
Ravi Verma

 

[Earl Kiosterud]

Ravi,

When Excel saves a file, it saves it with a name like the one you describe
(though usually longer). If that save is successful, it deletes the
original file, and renames the temporary one to the correct name. It sounds
as if the process isn't getting completed, possibly because of restrictions
in your network. Maybe delete rights.

 

[Ravi Verma]

Thnx very much. i would like to know how to setup the permissions for my
workgroup computers.

 

[Earl Kiosterud]

Ravi,

Although this question might be answered in this newsgroup, it's really a
network-related question. You might have good results in one of the Windows
newsgroups.

 

[Ravi Verma]

Thanks very much Earl.

Ravi,

Although this question might be answered in this newsgroup, it's really a
network-related question. You might have good results in one of the Windows
newsgroups.