Excel Cant open xls files HELP!! :: MrExcel Message Board


 FAQFAQ
   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   FavoritesFavorites   StatisticsStatistics 
 RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Online StoreOnline Store

MrExcel Message Board Forum Index -> Excel Questions

Cant open xls files HELP!!
Post new topic   Reply to topic
Last Thread | Next Thread  >   Printable version
  Author    Thread

TBK1
Welcome to the Board


Joined: 12 Sep 2002
Posts: 3


Status: Offline

 Reply with quote  

Brand New here and need help BAD.

Ill try to keep it short, I am not an expert EXCEl user.

had a xls file of 1800 person membership list and lost it!

had someone re-enter the entire data base and now have it on disk but cant open it.

when i try it says "file format is not valid"

this is what happened when i tried to save and reopen the original one that i lost!

using xp pro and ms office 4.3


Please help!!

Post Thu Sep 12, 2002 9:51 am 
 View user's profile Send private message

Andrew Poulsom
MrExcel MVP


Joined: 22 Jul 2002
Posts: 8120

Flag: Uk

Status: Offline

 Reply with quote  

As a start this might work.

Assume your file is called MyFile and is located in C:MyDocs. Assume also that your data is on Sheet1 in the file.

Open a new workbook and in cell A1 type:

='C:MyDocs[MyFile]Sheet1'!A1

If you're lucky this formula will return the value in cell A1 of the corrupted file.

Copy the formula down and across to recover as much as you can, then convert the formulas to values and save the new workbook.

Note this only recovers values, not formulas.

Post Thu Sep 12, 2002 10:02 am 
 View user's profile Send private message

TBK1
Welcome to the Board


Joined: 12 Sep 2002
Posts: 3


Status: Offline

 Reply with quote  

i have the new files on disk that are not corrupted but i cant open them on my comp.

they say they are xls files but when trying to open they say invalid format

Post Thu Sep 12, 2002 10:21 am 
 View user's profile Send private message

Andrew Poulsom
MrExcel MVP


Joined: 22 Jul 2002
Posts: 8120

Flag: Uk

Status: Offline

 Reply with quote  

If you can't open them they are corrupted aren't they?

Post Thu Sep 12, 2002 10:26 am 
 View user's profile Send private message

MarkHenri
Board Master


Joined: 03 Aug 2002
Posts: 106


Status: Offline

 Reply with quote  

If you send me the file, I'll try opening it with Office XP. It's error recovery is really good. I'd also like to look at it for evidence of viruses.

The typical reason for file corruption that we see here at the MS XL Support Group is either virus corruption, opening the a: drive door before Excel is finished writing to it, a dropped network connection (same basic reason as the a: drive scenario) and a system crash while editing. Did one of these happen to you?

BTW, what anti-virus software are you using?

_________________
Mark Henri

Microsoft Tier 1 Excel Support Technician

Post Thu Sep 12, 2002 11:29 am 
 View user's profile Send private message Send e-mail Visit poster's website MSN Messenger

TBK1
Welcome to the Board


Joined: 12 Sep 2002
Posts: 3


Status: Offline

 Reply with quote  

ok folks, i got it, it appears that the file was created in a newer version than i have. (office 2000) (versus office professional) had the person save as version 4.0 and i got it to come up and work. Thanks all

Post Thu Sep 12, 2002 11:45 am 
 View user's profile Send private message
  Display posts from previous:      

MrExcel Message Board Forum Index -> Excel Questions


Forum Jump:
Jump to:  

Post new topic   Reply to topic
Page 1 of 1



Add To Favorites

 


Forum Rules:
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB: 2.0.4 © 2001 phpBB Group

Need help posting your first question? Read how to post

Need extra help ? Couldn't get the answer you needed ? Get a free quote from our Consulting Team

Download Colo's HTML Maker utility for displaying your Excel Worksheet on the board.

Download VB HTML Maker to post your code on the board


Check out our new index to 485 Excel Articles.


Return to MrExcel Consulting

All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the Terms of Use
Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.