Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: "file format is not valid" error message


(!)

countrydaddy's Avatar
countrydaddy countrydaddy is offline
Computer Specs
Member with 18 posts.
THREAD STARTER
 
Join Date: Mar 2007
Location: Custer Park, IL
Experience: Intermediate
03-Mar-2007, 10:40 PM #1
Solved: "file format is not valid" error message
I am still using Excel 97 on Windows XP. I have been keeping a daily log in Excel for two years now. Yesterday I tried to open the file to make an entry and I received this message; "2006-07 Log book.xls: file format is not valid." Any idea what could have happened and how to retrieve the file. I checked all the forums I could find on the subject, but none helped. I have a lot of valuable info in that file and would sure hate to lose it. Thanks for any help.

Regards;
countrydaddy
kiwiguy's Avatar
Member with 17,584 posts.
 
Join Date: Aug 2003
Location: New Zealand
04-Mar-2007, 05:29 AM #2
The immediate answer would be that the file has become corrupt at the last save. This happens with any file from time to time.

This is why you MUST have copies of important data stored off the PC hard drive, as hard drives themselves also die without warning. Data that only exists on the hard drive is data that you do not care about losing.

There are many programs that "might" recover the data, most are not free.
None will give a guarantee, but before you start at least make a copy of the corrupt file now, so that any extraction of data that you try will not make it worse.

Look here for a start
http://www.freedownloadscenter.com/Best/xls-repair.html

This one allows you to try it as a demo, to see if it works. Only if it does would you purchase it:
http://www.cimaware.com/main/product...FR1Bggod4mHz2Q
ISys's Avatar
ISys ISys is offline ISys has a Profile Picture
Junior Member with 3 posts.
 
Join Date: Mar 2007
Location: A dark corner designed for coding
Experience: Advanced
04-Mar-2007, 07:03 AM #3
That almost sounds like the file you saved at the last save converted itself to a more recent file extenstion. Have you installed any Windows Service Packs or Updates since your last save? It could be that the very latest updates aren't supported for the '97 package.

You could try the converters or the viewers on this page, which may at least help you make a backup of your previous work:
http://office.microsoft.com/en-us/do...225121033.aspx

Good luck!

ISys
Rollin_Again's Avatar
Member with 4,693 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Advanced
04-Mar-2007, 10:05 AM #4
If the data is not sensitive email to rollin_again at hotmail dot com and I can try one of the recovery programs I have. When I have important documents that I can't afford to lose, I always email them to myself so there is a copy on the gmail server at all times.

Regards,
Rollin
countrydaddy's Avatar
countrydaddy countrydaddy is offline
Computer Specs
Member with 18 posts.
THREAD STARTER
 
Join Date: Mar 2007
Location: Custer Park, IL
Experience: Intermediate
06-Mar-2007, 03:54 PM #5
I think I lost the reply I tried to make to you guys, so I'll try again.

Thanks for your replies.

To kiwiguy: Yeah, I know I should back up important files, but I just got complacent with this one since I use it almost every day. I appreciate the links. Thanks.

To ISys: No, I haven't installed anything in the past couple of months. Thanks for the links; I'll check them out.

To Rollin_again: There isn't any sensitive material on the file, but you may find some stuff that you think is silly! I'll send you the file. Thanks.
Rollin_Again's Avatar
Member with 4,693 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Advanced
06-Mar-2007, 07:04 PM #6
I ran a recovery program on the file and it can now be opened. I have emailed you a copy of the updated workbook. Check it to make sure the data is correct.

Regards,
Rollin
countrydaddy's Avatar
countrydaddy countrydaddy is offline
Computer Specs
Member with 18 posts.
THREAD STARTER
 
Join Date: Mar 2007
Location: Custer Park, IL
Experience: Intermediate
07-Mar-2007, 03:57 PM #7
Rollin,
I received the file back from you and it's beautiful. Whew!!!...I am so relieved. Can't thank you enough! Sure glad I signed up with Tech Guy... and sure glad you did too!
Gratefully,
Countrydaddy
Rollin_Again's Avatar
Member with 4,693 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Advanced
07-Mar-2007, 05:55 PM #8
Glad to help out! Have we learned a lesson about keeping backups??

Feel free to mark the thread as solved from the thread tools at the top of the page. One more thing, Welcome to the Tech Support Boards!!

Regards,
Rollin

Last edited by Rollin_Again; 07-Mar-2007 at 06:00 PM..
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑