Excel read only issue.

Swordfish

Swordfish

Swordfish

Soldato
Joined
17 Jan 2006
Posts
2,890
Location
Dundee
I have a problem with a small network of 3 PC's.

All PC's are Windows 7 and are in the same homegroup.

One PC (PC1) has all the files that each user uses but when someone opens up the same excel file on either PC2 or PC3 at the same time the file is opened on PC1 no warning comes up saying the file is in use. Now this happened until Friday and only started on Monday of this week.

The share option for multiple users in Excel is disabled.

Any suggestions because the file is getting altered by two people at the same time and this is causing issues.
 
Last edited:
Is there any code in this (on the on open event of the workbook object), you can suppress the warnings in vba.
 
dazzerd said:
Is there any code in this (on the on open event of the workbook object), you can suppress the warnings in vba.
Click to expand...


I would doubt it to be honest at network is only used by 3 women in a small reception. It is really a strange one.

It will be Monday morning now before I can check it out.
 
If all computers saves a change does it show on the other computers. I'm wondering if someone isn't pointing at the network copy any more.
 
I have tried it myself browsing the the network file and opening and then opening the same file on a different machine and no warning. Really weird.
 
Do the same, but then make changes on the first machine, then save.

Then make changes on the 2nd machine and save, does it warn you that the other user has made changes?
 
Just been to test it again and it all is working as it should be. Without me doing anything as such. When files are opened on a 2nd or 2rd machine the locked for editing error now shows up.

No idea why it did not before but problem solved.

Cheers for all replies.
 
You must log in or register to reply here.
Back
Top Bottom