lost worksheet
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: lost worksheet

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a spreadsheet with 25 worksheets. I had one spread sheet open and was copying formulas to another spreadsheet. Later I went back to my original spreadsheet and the worksheet was missing. I've done several things but cannot find the worksheet. I know it is out there, because the totals from the worksheet are still reflecting in my grandtotal worksheet.

    What can I do to find my missing worksheet?

    P.S. I have tried the unhide and the unhide is not available. I also tried to add a new worksheet and just retype the existing info, but as soon as I name the worksheet the same as the missing worksheet, I get kicked out of excel and get a Dr Norton error. So even though the unhide is not available, I know the worksheet is still out there

    [ This Message was edited by: GERIP on 2002-02-25 08:07 ]

    [ This Message was edited by: GERIP on 2002-02-25 08:10 ]

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Format-Sheet-Unhide.

    If unhide is not available, there are no hidden sheets.
    ~Anne Troy

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Look under the Windows menu for Unhide... If it's present perhaps you inadvertently hid it.

    [ This Message was edited by: Mark W. on 2002-02-25 07:54 ]

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I know it is out there, because the totals from the worksheet are still reflecting in my grandtotal worksheet.
    Highlight one of the cells that you know is still referencing this missing sheet then click on "tools" then "auditing" then "trace precendents"

    this will bring up a little spreadhseet icon which points to your cell, signifying a link..... bottom left of it is a black dot : double click this dot and it will take you to "goto" with a reference to the link, click on the link so it appears in the "reference" field then hit "OK"..... it should take you to the scource, ie your missing sheet, if it's open - maybe if you get there you can figure out where it is or what's hiding it....

    See if it also has an external links appearance, in which case it's been saved outside the workbook you're in....

    (Trace dependants and trace precedents are sometimes handy left on as you can use them to navigate around when auditing/ checking your workbook structure)

    anyhow, long shot, but hope it helps out
    Chris

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi

    Nows not the time i go with suggests above but i ALWAYS go on and on about regula backup!

    Here is such a case... please archie your work so if all lost your up and running with little loss.

    Simple set save to create backup aswell

    Rdgs

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com