Re: How do I recover an Excel File??

Thank you Jan for your help.

I have some older copies of the list and I will just have to rebuild it a
bit, and go on from there.

Take care,
Mark

"Jan Karel Pieterse" wrote:

Hi J.,

I have the 2007 home/student version, that operates with Microsoft Vista.
Every morning before I open the file (and its been two weeks since I've
backed it up)...I change the date on the file...so today I made it "SA Client
Outreach 10.10.07"...

When I opened up the file, it said this: The file you are trying to open,
'SA Client Outreach 10.10.07.xls', is in a different format than specified by
the file extension. Verify that the file is not corrupted and is from a
trust source before opening the file. Do you want to open the file now?

It then gives me the option of saying "Yes, no, or help." If I click yes,
it opens the file but its blank. The file itself was massive, but it now
says that it is 0 bites.

I have no idea how to recover the file, or what happened to it. Its as if
it just vanished into thin air.

Do you have any idea what I should do, or where it might have gone? Any
assistance you might be able to give I would really appreciate.

The new native Excel 2007 file format comes with a different extension by
default an if you change that extension, Excel might complain (as you've
discovered. The proper extension for the 2007 file format is either:

.xlsx (workbooks with no macros)
.xlsm (workbooks with macros).

If the filesize says 0 bytes, well, that is what it contains: nothing. I'm
afraid you'll have to start digging for a backup copy (you do make a backup once
in a while?) or for an older copy.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com


.

Relevant Pages

  • Re: How do I recover an Excel File??
    ... I had exactly the same problem...is this an excel bug as it is the second ... it opens the file but its blank. ... The new native Excel 2007 file format comes with a different extension by ...
    (microsoft.public.excel.misc)
  • Re: How do I recover an Excel File??
    ... 'SA Client Outreach 10.10.07.xls', is in a different format than specified by ... it opens the file but its blank. ... The new native Excel 2007 file format comes with a different extension by ...
    (microsoft.public.excel.misc)
  • Re: Snow Leopard - Lost File Extensions & Custom Icons
    ... the decision as to which application opens the file should be ... *that* doesn't exist it should use the file extension. ... to a filesystem that didn't understand UTIs, and conversely a filetype ...
    (uk.comp.sys.mac)
  • Re: GIF
    ... >> specify which one is used when I open a file with an HTML extension. ... >> specify that I wanted to use Firefox instead of IE to open HTML files? ... >> Or Nullsoft Winamp rather than Microsoft Windows Media Player to open ... >changes color, and when you let up on the mouse button, it opens. ...
    (alt.usage.english)
  • Re: Running program files on XP with non-executable extension?
    ... >> Will start up word and load a document regardless of file ... >> Renaming it to book.xyz still opens it. ... > have unregistered extensions default to give the ... > the associations by extension kept to a minimum. ...
    (comp.security.misc)