Results 1 to 5 of 5
  1. #1
    mldeitrich
    Guest

    blank spreadsheet

    What could have happened to an Excel Spreadsheet that was saved, still in the directory with a file size of 15K but when opened it is entirely blank?

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

    Re: blank spreadsheet

    Not sure what you mean by "entirely blank." If you mean that you have a gray screen with no spreadsheets visible, then go to the window menu and select unhide. If a window pops up asking what to unhide, select your workbook and click OK. If that is not what you have, could you be a little more explicit?
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    eastern Connecticut, Connecticut, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: blank spreadsheet

    Maybe it really is blank...
    Using Excel 8 SR-2 (Office97), if I save a new workbook with no entries (using 3 worksheets as the default for a new workbook), the file size is 14K. Saving a new 'empty' workbook with 16 worksheets is 17K. Sounds like you could have a workbook with nothing in it.

  4. #4
    mldeitrich
    Guest

    Re: blank spreadsheet

    What I meant was that there is no data at all on the sheet. It is totally blank and the sheet tabs are no longer named, yet there is a file name and it opens into excel when you click it. It has two full sheets of data of aout 15 rows and 30 columns. I don't understand how there can be a file name, file size and an entirely blank spreadsheet. Thank you for any help.

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

    Re: blank spreadsheet

    There is one other possibility. Open the workbook and then select Sheet from the Format menu. If the Unhide command is not grayed out, then click on it and see it the sheets are hidden.

    Unfortunately, it sounds like someone saved a new empty workbook with the same file name in the same directory, and then clicked on "Yes" when asked if they wanted to replace the existing file. If that is the case, then look in your trash basket to see if the file is by any chance still there. If not, and you don't have a backup, then your file is probably gone.
    Legare Coleman

Posting Permissions

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