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.

Solved: Excel won't save file

Discussion in 'Business Applications' started by jcaldw737, Jul 8, 2010.

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

    jcaldw737 Thread Starter

    Joined:
    Jul 8, 2010
    Messages:
    3
    Excel 2007 says the file is in use and won't save it, but no one else is using it. Have checked and Excel shows only one user. After some time, Excel will save the file.
     
  2. BenTechMac

    BenTechMac

    Joined:
    Jul 8, 2010
    Messages:
    303
    Hello,

    Depending where you file is saved may cause this type of issue, try moving the file to your desktop. then open it from there and see if you suffer from same problem.

    Opening a file across a shared networking drive or something like that could cause these issues.

    Windows some times keeps hold of the file in its memory even if the file is closed in the program.

    See what happens ?
     
  3. jcaldw737

    jcaldw737 Thread Starter

    Joined:
    Jul 8, 2010
    Messages:
    3
    Thanks, I can see that this would be a great idea if the workbook didn't have any links. But in this case there are actually 3 workbooks with links between them. It seems like saving one of the workbooks to the desktop would mess up the links. Right?
     
  4. BenTechMac

    BenTechMac

    Joined:
    Jul 8, 2010
    Messages:
    303
    Yep it probably would cause a problem.

    Does this issue happen every time you have the file open?

    Are the other machines that use the file switched off? Try that.. or restart them at least. to release any lock it has over the file.
     
  5. jcaldw737

    jcaldw737 Thread Starter

    Joined:
    Jul 8, 2010
    Messages:
    3
    Thanks again!

    I'm pretty confident that at least some of the other machines are on and haven't restarted since they opened the file. I think it would be hard to get them all to reboot. Think I could write some kind of macro that would "clear them out"? We might be able to get them to run that. Even give them an "on close" message to remind them to run the macro which I guess would be an a separate workbook.

    thanks again
     
  6. 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/934305

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice