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

    Problem with Excel (Excel 2000)

    Does anyone know how to recover a document in Excel when it disappears for no reason and when you go to open it up it's empty yet the file states it has 1,263 KB. I tried to do a system restore, and restored the system back one day, but that didn't work. I used the Office Recovery Demo and that worked, but I don't have the money to spend on the program. Does Excel have a way to recover documents that sort of corrupt or hide themselves but are still there. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

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

    Re: Problem with Excel (Excel 2000)

    Are the cells that contained the data visible, or are the row and/or column headers missing from the display?

    If the cells are visible on the screen, you might try selecting all cells and then select Cells from the format menu and make sure that the font color is set to Automatic or some color that will display on your background color.
    Legare Coleman

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

    Re: Problem with Excel (Excel 2000)

    When I go to open it up, nothing opens up. I don't see the workbook or anything, but the file says there is information in it.
    So when I click on File|Open, I get nothing but a blank screen. I don't even see a new workbook. The demo of Excel recovery recovered it, but it was only a one time demo. The cost to buy it is $149.00 and I can't afford that so I was wondering if Excel had a recovery function <img src=/S/boxedin.gif border=0 alt=boxedin width=25 height=20>

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

    Re: Problem with Excel (Excel 2000)

    Here is a set of things I advise regularly:

    Options to try and open a corrupt file

    - Set calculation to manual
    - open the file, but disable macros (assuming you've set macro security to medium: Tools, Macro, security)
    - As soon as you've clicked the disable macros button, press control-pageup or control-pagedown, thus changing sheets.

    If that does not work, try creating a link to the file:

    ='c:my documents[MyFileName.xls]Sheet1'!A1

    and copy right and down. This at least gets you the worksheets values.

    if you don't know the sheet names, enter this:

    ='C:PathToFile[MyFileName.xls]'!A1

    and press enter

    If XL (2000) is able to extract them, it will prompt you for a sheet name.

    Sometimes the Excel viewer, Word or even Internet explorer (v5) enables you to open the file and copy information out of it.

    If the file is not protected, maybe you can open it with OpenOffice (www.Openoffice.org).

    Also, Excel XP can sometimes repair XL files with trouble.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Star Lounger
    Join Date
    Feb 2002
    Location
    Illinois, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem with Excel (Excel 2000)

    Just a guess, but it is possible that the entire workbook has accidentally been "hidden." Have you tried clicking Windows | Unhide?

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

    Re: Problem with Excel (Excel 2000)

    OH THANK YOU SO MUCH SPENCE. THAT WAS IT!!!!!!!!!!!!! I did everything but windows unhide. Thank GOD we have forums like this around because I couldn't find the answer on the Microsoft site. YAY, SPENCE <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

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