Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Woodbridge, New Jersey, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel worksheets disappearing (Office 2000 Premium)

    I will be working in Excel two or three times a day, and then out of nowhere, the worksheets disappear. I have done a Detect and Repair and that doesn't bring them back. I am running Windows XP, and I actually have to do a system restore to have them come back. When I do a system restore, then I lose anything I previously downloaded and have to re download.

    Can anyone tell me why they think the worksheets are disappearing? <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel worksheets disappearing (Office 2000 Premium)

    Do you really mean worksheets, or do you mean workbooks? If you really do mean worksheets, do they disappear from the workbook while you have it open and are working on it?
    Legare Coleman

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel worksheets disappearing (Office 2000 Premium)

    Could it be that their window is simply hidden from view?

    - Window, unhide. If any are listed (except personal.xls if it's there), select them and OK.

    - Window, arrange, tiled brings back into view those that somehow got pushed outside of the viewable area.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Woodbridge, New Jersey, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel worksheets disappearing (Office 2000 Premium)

    Windows hide/unhide hides the entire page. I am referring to the workbooks that Iset up on the bottom of the page. Something is making them disappear. After I do a system restore, they come back , that's very strange.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Woodbridge, New Jersey, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel worksheets disappearing (Office 2000 Premium)

    Yes that's exactly what happens

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel worksheets disappearing (Office 2000 Premium)

    Probably, the worksheets don't disappear, but the sheet tabs are hidden. You can hide/unhide these with Tools/Options..., View tab, Sheet Tabs check box. This setting is stored with the workbook. so changing this setting in one workbook doesn't affect other workbooks. Even if sheet tabs are hidden, you should be able to switch between worksheets within a workbook by using Ctrl+PageUp and Ctrl+PageDown.

    I have no idea why the sheet tabs should become hidden spontaneously. Perhaps one of the workbooks you are working with contains a macro that hides them?

  7. #7
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Woodbridge, New Jersey, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel worksheets disappearing (Office 2000 Premium)

    Yes Legare that's what happens exactly

  8. #8
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Woodbridge, New Jersey, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel worksheets disappearing (Office 2000 Premium)

    Hi Hans: I checked what you said in Tools|Options. The box is already checked. If it is a macro that's hiding them would you know how I can find and disble the macro? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel worksheets disappearing (Office 2000 Premium)

    Open the workbook with the shift key held down. This disables the execution of automatic macros. See if that makes a difference.

    To find macros:
    Switch to the Visual Basic Editor (Alt+F11)
    Make sure the Project Explorer is visible (Ctrl+R)
    Expand your workbook in the Project Explorer. If it contains standard modules, there will be a section named Modules. Macros can also be contained in the Excel objects representing the workbook as a whole (ThisWorkbook) and the individual sheets. Double click these to see if they contain macros.

  10. #10
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel worksheets disappearing (Office 2000 Premium)

    Do you have anti-virus software on this system with up-to-date virus signatures? It might be worth a scan with an up-to-date scanner.
    Legare Coleman

  11. #11
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Excel worksheets disappearing (Office 2000 Premium)

    If you right cllick on the "VCR" buttons on the bottom left, do you get a pop-up that shows all the sheets you have created, like the picture attached? (If more than 16 sheets, it will have a "More Sheets..." submenu.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  12. #12
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Woodbridge, New Jersey, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel worksheets disappearing (Office 2000 Premium)

    Yes I belong to McAfee VirusScan On line so everything is up to date every day

  13. #13
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Woodbridge, New Jersey, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel worksheets disappearing (Office 2000 Premium)

    Yes, one minute they are there, then I look down and they are gone out of the workbook

  14. #14
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Woodbridge, New Jersey, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel worksheets disappearing (Office 2000 Premium)

    How do I switch to Visual Basic? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  15. #15
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel worksheets disappearing (Office 2000 Premium)

    The instructions are in my previous reply <img src=/S/rtfm.gif border=0 alt=rtfm width=24 height=23> - type Alt+F11 on the keyboard to switch to the Visual Basic Editor, then type Ctrl+R on the keyboard to display the Project Explorer.

Page 1 of 2 12 LastLast

Posting Permissions

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