Solved Problem with networked xls file

Intel / D945gnt
July 5, 2011 at 00:10:59
Specs: Windows XP, P4 1.8GHZ/ 1GB
Hi everybody,
In the office we have a small network used to share documents. Problem is with an Excel file which now can only be opened from the "server". Before there was no problem, could be opened by anyone. Now if someone else tries to open it, we get the message "Can't open file. Contact your network administrator". I tried to make a copy in the same directory ("server") from another workstation but got the message "File is open or there is not enough space on the disk". I tried to save it under a new name at the "server" but the new file behaves as the previous one!
No need to say all other documents on the "server" open OK by all...

Any other Ideas?? (seems I'm run out....)


See More: Problem with networked xls file

Report •


#1
July 5, 2011 at 06:31:58
I'm not sure what you mean by can only be opened from the "server".

Why do you keep putting quotes around the word "server"?

Please describe your set-up in a little more detail.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
July 5, 2011 at 06:40:15
"server" is the machine that the documents are stored. It's a shared directory where other machines can read/write from there....

Report •

#3
July 5, 2011 at 07:34:16
✔ Best Answer
So are you saying that the file can only be opened when you are sitting at the machine where the file resides?

Is it really a server as in a file server or is it somebody's desktop where one of the folders is shared?

Is the workbook itself shared or just the folder?

Could the permissions on the file have changed such that only those that are logged into the machine where the file resides can open it?

Have you tried copying the contents of the file into a new file and tried to access that one over the network?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question