ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel getting Error - file format is not valid WHEN OPENING (https://www.excelbanter.com/excel-discussion-misc-queries/42053-excel-getting-error-file-format-not-valid-when-opening.html)

babu

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.

Dave Peterson

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


All times are GMT +1. The time now is 11:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com