Unable to Open and Save Excel files in the shared drive using Excel 2007

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

dhoodz_1981

Thread Starter
Joined
Jun 23, 2010
Messages
5
Hi! i need you help!.. I am unable to open or save files in the shared drive using Excel 2007 but i can open/save excel 2007 files saved in my local drive

The error message I get when i try to open is "Could not open...." followed by the path and excel name.

This is the error message i get when i try to save in the shared drive:

Microsoft office excel cannot acces the file". There are several possible reasons:

the file name or path does not exist
the file is being used by another program
the workbook you are trying to save has the same name as a currently open workbook

Please help
 

DaveA

David
Trusted Advisor
Spam Fighter
Joined
Nov 16, 1999
Messages
16,926
Do you have write and change permissions on this shared folder?
 
Joined
Oct 20, 2004
Messages
7,837
Welcome to the forum! :)
Excel has a history of having problems with deeply shared folders - are you able to save to that same shared drive but by going up a few levels?
Also, make sure no one else has the file open at the same time or it is being used by, say Access as a linked file at that time.
 

dhoodz_1981

Thread Starter
Joined
Jun 23, 2010
Messages
5
@DaveA, yes i have all that rights to that shared folder, the problem is I can open and save file using Excel 2003 but I can not do any of these in Excel 2007, which I find it wierd. I have both excel 2003 and 2007 installed in my laptop. I dont have any issue in opening or saving excel files for both 2003 and 2007 version in my local drive, i just can't do these in the shared drive.
 

dhoodz_1981

Thread Starter
Joined
Jun 23, 2010
Messages
5
Welcome to the forum! :)
Excel has a history of having problems with deeply shared folders - are you able to save to that same shared drive but by going up a few levels?
Also, make sure no one else has the file open at the same time or it is being used by, say Access as a linked file at that time.

hi slurpee, I am the only one using the files at that and Access has no link to that file in anyway. By the way i forgot to mention that the shared drive is located in another country, do you think this has something to do with the issue. thanks!
 
Joined
Oct 20, 2004
Messages
7,837
hi slurpee, I am the only one using the files at that and Access has no link to that file in anyway. By the way i forgot to mention that the shared drive is located in another country, do you think this has something to do with the issue. thanks!
The location, per se, doesn't, but your firewall - or the one there - could.
 

dhoodz_1981

Thread Starter
Joined
Jun 23, 2010
Messages
5
The location, per se, doesn't, but your firewall - or the one there - could.

hi slurpee, the forums you gave me is not applicable i think, cz we are using windows XP SP2 and the forum was talking about windows vista.. firewall is ruled out as other users are able to perform open and save with no issue.
 

Triple6

Rob
Moderator
Joined
Dec 26, 2002
Messages
52,933
hi slurpee, the forums you gave me is not applicable i think, cz we are using windows XP SP2 and the forum was talking about windows vista.. firewall is ruled out as other users are able to perform open and save with no issue.
I've edited your thread, somehow you had managed to post a huge amount of code into the middle of your text.
 
Joined
Oct 20, 2004
Messages
7,837
And if you and others each have individual firewalls, then your firewall is not necessarily ruled out.
Are you all using the same anti-virus or are there several of those being used?
 

dhoodz_1981

Thread Starter
Joined
Jun 23, 2010
Messages
5
And if you and others each have individual firewalls, then your firewall is not necessarily ruled out.
Are you all using the same anti-virus or are there several of those being used?

hmmm, we are all using the same anti virus. what should i check on the firewall then?
 
Joined
Oct 20, 2004
Messages
7,837
Make sure that your firewall is not blocking Excel from accessing what it may consider an outside location. The easiest way to do this is just to turn off your firewall for a moment, then see if you can save a file using Excel 2007 to your shared drive.
Be sure to turn your firewall back on afterwards! :)
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top