Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 24th 05, 04:25 PM
babu
 
Posts: n/a
Default Excel getting Error - file format is not valid WHEN OPENING

My excel file was working fine until yesterday.suddenly when i try to open
the file it giving the error message "file format is not valid " But i can
open the file in Ms WORD. AND I CAN SEE THE DATA.
SO WHAT I DID I COPIED ALL THE DATA AND PASTED IN NEW EXCEL SHEET.
I CAN GET THE DATA BUT NOT THE FORUMLA..??

I HAVE LOT OF FORMULA IN EXCEL SHEET.. CAN ANYONE HELP ME HOW TO RECOVER IT?
HOW TO OPEN THE EXCEL WHICH IS GIVING THE ABOVE ERROR.

  #2   Report Post  
Old August 24th 05, 09:09 PM
Dave Peterson
 
Posts: n/a
Default

MSWord allows you to open .xls files. The bad news is that if you save that
file in MSWord (as an MSWord document with .xls as the extension), that you've
lost most of your excel features--formulas and the like.

Do you have a backup copy of this workbook?

Any chance you emailed it to someone--you could have an earlier version in your
sent folder--or ask the recipient to send a copy back.

(or maybe your IT folks back up the files??????)

(I think you did the best you could (open in MSWord and copy|paste into Excel),
if you don't have a backup.)

babu wrote:

My excel file was working fine until yesterday.suddenly when i try to open
the file it giving the error message "file format is not valid " But i can
open the file in Ms WORD. AND I CAN SEE THE DATA.
SO WHAT I DID I COPIED ALL THE DATA AND PASTED IN NEW EXCEL SHEET.
I CAN GET THE DATA BUT NOT THE FORUMLA..??

I HAVE LOT OF FORMULA IN EXCEL SHEET.. CAN ANYONE HELP ME HOW TO RECOVER IT?
HOW TO OPEN THE EXCEL WHICH IS GIVING THE ABOVE ERROR.


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003, It wont print in landscape format STEVE665 Excel Discussion (Misc queries) 1 July 12th 05 04:47 PM
Imported Date & Time format with calcs. managed in excel from imrp Todd F. Excel Worksheet Functions 0 July 8th 05 09:03 PM
How do I report a Date Format bug in Excel 2003 to Microsoft ? KymY Excel Discussion (Misc queries) 1 April 6th 05 12:45 PM
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . P.S.Sodha Excel Discussion (Misc queries) 0 April 2nd 05 01:53 PM
How do I convert Excel 2003 to Excel 98 format? Lady Layla New Users to Excel 8 March 31st 05 12:47 AM


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017