Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Plano, Texas, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    On random days when I start up Excel 2003, under Vista, I get a warning that the sheet is in use and I need to click NOTIFY to continue. I click NOTIFY, make my changes and usually before I'm through doing that I get notified that the sheet is available for editting. Some days this doesn't happen and I just open a sheet, edit it, and save it. But other days it happens on more than one sheet. This started happening a few weeks ago and never happened before. Eventually I get notified, but its annoying. Any ideas what causes this and how to stop it? And, anticipating the question, no, I have no sheets at all open when I first start Excel or load the first sheet.

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 986 Times in 916 Posts
    Normally caused by not closing the sheet properly. Do you close Excel manually or let Windows do it when you shut down?

    cheers, Paul

  3. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    Plano, Texas, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I always close all open apps before shutting down. I also always close open sheets before exiting the app unless I've made a change and then I do a save first. But this has happened sometimes three days in a row (I have a sheet I update each morning).

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    Is the file on a network or on your machine?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •