1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

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

Discussion in 'Business Applications' started by dhoodz_1981, Jun 23, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. dhoodz_1981

    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
     
  2. DaveA

    DaveA David Trusted Advisor

    Joined:
    Nov 16, 1999
    Messages:
    11,849
    Do you have write and change permissions on this shared folder?
     
  3. slurpee55

    slurpee55

    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.
     
  4. dhoodz_1981

    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.
     
  5. dhoodz_1981

    dhoodz_1981 Thread Starter

    Joined:
    Jun 23, 2010
    Messages:
    5

    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!
     
  6. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    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
     
  7. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
  8. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    The location, per se, doesn't, but your firewall - or the one there - could.
     
  9. dhoodz_1981

    dhoodz_1981 Thread Starter

    Joined:
    Jun 23, 2010
    Messages:
    5

    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.
     
  10. Triple6

    Triple6 Rob Moderator

    Joined:
    Dec 26, 2002
    Messages:
    45,574
    I've edited your thread, somehow you had managed to post a huge amount of code into the middle of your text.
     
  11. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Thanks, Triple6 - I saw it and figured it out, but sheesh!
     
  12. slurpee55

    slurpee55

    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?
     
  13. dhoodz_1981

    dhoodz_1981 Thread Starter

    Joined:
    Jun 23, 2010
    Messages:
    5

    hmmm, we are all using the same anti virus. what should i check on the firewall then?
     
  14. slurpee55

    slurpee55

    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! :)
     
  15. Sponsor

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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/931066