+ Reply to Thread
Results 1 to 16 of 16

Spreadsheet Has Disappeared!

  1. #1
    Registered User
    Join Date
    01-07-2009
    Location
    Cambridge England
    MS-Off Ver
    Excel 2007
    Posts
    6

    Spreadsheet Has Disappeared!

    Not come across this before, but a spreadsheet I use regularly now appears to open, but does not appear, although it does show that I am in a particular cell.

    When I exit excel it asks me if I want to save the worksheet, as normal.

    I have closed all other worksheets and tried again, and rebooted the laptop.

    Any help appreciated.

    Thanks

  2. #2
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    re: Spreadsheet Has Disappeared!

    hi

    From the Excel menus, try Windows - Unhide.

    hth
    Rob
    Rob Brockett
    Kiwi in the UK
    Always learning & the best way to learn is to experience...

  3. #3
    Registered User
    Join Date
    01-07-2009
    Location
    Cambridge England
    MS-Off Ver
    Excel 2007
    Posts
    6

    re: Spreadsheet Has Disappeared!

    Hi thanks for that suggestion, I clicked unhide and it looked like it did it, and the windows boxes are all shown as per the spread sheets I can view, but I still cannot see it - any other ideas?

  4. #4
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    re: Spreadsheet Has Disappeared!

    hi again,

    Sorry my previous answer was poorly considered & is unlikely to help if you can still see what the active cell is.

    For future threads, please take care that your thread titles meet the forum rules - I think this title does, but it could be made clearer :-)

    Here's one other option that may help:
    In Excel, press [alt + F11] to open the VBE
    press [ctrl + G] to open the Immediate pane
    type in this code
    Please Login or Register  to view this content.
    & press [enter]
    then close the VBE & check Excel.

    If this one doesn't help I need a bit more info for further suggestions.
    Is the workbook/worksheet/range protected?
    If so, can you remove the protection & then resize the spreadsheet, before re-protecting it?
    Are there any macros in the file?
    Or macros in any other files which are open?

    hth
    Rob

  5. #5
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    re: Spreadsheet Has Disappeared!

    Good luck, I'm off house hunting now but will check this thread again when I get home tonight.

    Rob

  6. #6
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    re: Spreadsheet Has Disappeared!

    it may be of the screen, perhaps someone opened it in a dual monitor and saved it in the right hand screen or something like that. try ctrl+f7 then use arrow keys to see if you can find it
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  7. #7
    Registered User
    Join Date
    01-07-2009
    Location
    Cambridge England
    MS-Off Ver
    Excel 2007
    Posts
    6

    re: Spreadsheet Has Disappeared!

    Thanks for all your help on here - I have just gone back into the spreadsheet and it is now working. Maybe the unhide I did only works when you go back into the spreadsheet?

  8. #8
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    Re: Spreadsheet Has Disappeared!

    I'm pleased we could help - thanks for the feedback :-)

    Can you please mark this thread as solved by editing the prefix of your first post?

    Rob

  9. #9
    Registered User
    Join Date
    02-14-2014
    Location
    Colobia
    MS-Off Ver
    2010
    Posts
    1

    Re: Spreadsheet Has Disappeared!

    Hi!

    My complete shreadsheet dissapired, no idea why. I was just working on it and when I was going to modify the size of a cell, it just disappeared. Here's the printscreen:

    Printscr.png

    Can anyone help me with this?

  10. #10
    Registered User
    Join Date
    05-02-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Spreadsheet Has Disappeared!

    Quote Originally Posted by martindwilson View Post
    it may be of the screen, perhaps someone opened it in a dual monitor and saved it in the right hand screen or something like that. try ctrl+f7 then use arrow keys to see if you can find it
    Man, I know it's years later...but this truly helped me out...that was my issue! thanks!

  11. #11
    Registered User
    Join Date
    11-02-2017
    Location
    San Diego CA
    MS-Off Ver
    2010
    Posts
    1

    Re: Spreadsheet Has Disappeared!

    I know it's been several years, and I have no idea if anyone still posts here, but I have a similar problem. I was updating two Excel spreadsheets on Tuesday night, saved them and closed Excel. On Wednesday, I opened Excel and the spreadsheets had disappeared. They aren't hidden or in the recycle bin, and Cortana couldn't find either of them. Both are still listed when I open Excel under RECENT WORKBOOKS, but when I click on them, it says NOT FOUND. The rest of my spreadsheets are still in the same folder, but those two just seemed to have vanished. Any ideas?

  12. #12
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: Spreadsheet Has Disappeared!

    radioproducer1,
    you should start a new thread so this comes up as an unanswered thread (and to stay within the forum rules of not posting queries in others threads.)

    As for the issue - I imagine the solution is related to something you aren't telling us, and have forgotten - for example maybe you also were moving some files.
    In the absence of that information - check to see of your system does any sort of backing up of files.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  13. #13
    Registered User
    Join Date
    10-01-2010
    Location
    Gold Coast, Queensland
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Spreadsheet Has Disappeared!

    I have just now 'returned' a 'disappeared' spreadsheet by going to View/New Window. Don't know why the sheet disappeared, nor why this fixed it.

  14. #14
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Spreadsheet Has Disappeared!

    Quote Originally Posted by dejayajay View Post
    I have just now 'returned' a 'disappeared' spreadsheet by going to View/New Window. Don't know why the sheet disappeared, nor why this fixed it.
    Thanks for sharing that
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  15. #15
    Registered User
    Join Date
    03-13-2020
    Location
    Michigan
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Spreadsheet Has Disappeared!

    I have the same problem. I was working on a spreadsheet - two were open at the same time.

    I walked away for a few minutes...when i came back, the spreadsheets appeared to still be open but nothing was visible.

    I cannot post an example of this because there is nothing to see...see below

    Attachment 667264

    Also, when I hit "full screen" the info on the sheet appears, minus the headings. When I hit the escape button, it goes back to "nothing."

    HELP!!!

  16. #16
    Registered User
    Join Date
    03-13-2020
    Location
    Michigan
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Spreadsheet Has Disappeared!

    Thank you!!! this solved my problem as well!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1