Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

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


(!)

dhoodz_1981's Avatar
dhoodz_1981 dhoodz_1981 is offline
Junior Member with 5 posts.
THREAD STARTER
 
Join Date: Jun 2010
23-Jun-2010, 04:43 PM #1
Unable to Open and Save Excel files in the shared drive using Excel 2007
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's Avatar
Computer Specs
Trusted Advisor with 10,612 posts.
 
Join Date: Nov 1999
Experience: Beginner
23-Jun-2010, 10:07 PM #2
Do you have write and change permissions on this shared folder?
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
24-Jun-2010, 08:40 AM #3
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's Avatar
dhoodz_1981 dhoodz_1981 is offline
Junior Member with 5 posts.
THREAD STARTER
 
Join Date: Jun 2010
24-Jun-2010, 09:30 AM #4
@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's Avatar
dhoodz_1981 dhoodz_1981 is offline
Junior Member with 5 posts.
THREAD STARTER
 
Join Date: Jun 2010
24-Jun-2010, 09:39 AM #5
Quote:
Originally Posted by slurpee55 View Post
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!
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
24-Jun-2010, 09:43 AM #6
I found several other threads of this type, with most ending with the information that this is an issue that MS is working on....
However, you might check this out to see if any of these help:
http://support.microsoft.com/kb/271513
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
24-Jun-2010, 09:48 AM #7
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
24-Jun-2010, 09:53 AM #8
Quote:
Originally Posted by dhoodz_1981 View Post
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's Avatar
dhoodz_1981 dhoodz_1981 is offline
Junior Member with 5 posts.
THREAD STARTER
 
Join Date: Jun 2010
24-Jun-2010, 07:10 PM #9
Quote:
Originally Posted by slurpee55 View Post
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.

Last edited by Triple6; 24-Jun-2010 at 09:21 PM.. Reason: Edited out code
Triple6's Avatar
Triple6   (Rob) Triple6 is offline
Computer Specs
Moderator with 41,625 posts.
 
Join Date: Dec 2002
Location: Canada
Experience: Advanced
24-Jun-2010, 09:21 PM #10
Quote:
Originally Posted by dhoodz_1981 View Post
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.
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
25-Jun-2010, 04:57 AM #11
Thanks, Triple6 - I saw it and figured it out, but sheesh!
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
25-Jun-2010, 04:59 AM #12
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's Avatar
dhoodz_1981 dhoodz_1981 is offline
Junior Member with 5 posts.
THREAD STARTER
 
Join Date: Jun 2010
25-Jun-2010, 10:21 AM #13
Quote:
Originally Posted by slurpee55 View Post
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?
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
25-Jun-2010, 12:36 PM #14
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!
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
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.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


Similar Threads
Title Thread Starter Forum Replies Last Post
Solved: Peculiar Happenings When Opening and Saving as docx in MS Word 2007 Galleherjazz Business Applications 1 01-Nov-2009 07:47 PM
Opening XT files on external hard drive using Vista olyviking All Other Software 0 16-Sep-2009 12:31 AM
unable to open files. garywillams Windows XP 2 27-Aug-2009 11:14 AM
How to get my files off the hard drive of a dead computer and on to another computer? placebo213 Hardware 3 10-Jul-2009 07:17 AM
Word was unable to open the datasource - column count limit user888 All Other Software 2 22-Oct-2008 02:13 AM

WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑