I Am Trying To Open Files Called "Excel 97 Templates" With My Excel For Windows 95, Version 7.0. I Get The Message "(filename).xls File Format Is Not Valid". What Gives? Is The "Excel 97" Saved File Just Unreadable By My Version?

RenDC

» Interview Questions and Answers » Questions » News Feed » Tutorials » rendc.com

Question and Answer:

Home MS Excel

⟩ I am trying to open files called "Excel 97 Templates" with my Excel for Windows 95, Version 7.0. I get the message "(filename).xls file format is not valid". What gives? Is the "Excel 97" saved file just unreadable by my version?

Excel 97 is not backwards-compatible with Excel 95/7.0. Files saved as Excel 97 files do not open in Excel 95/7.0. The standard (and not very friendly) message offered by Excel when you try to open a 97 file in 95 is the "File format is not valid".

If you know someone with Excel 97, they should be able to open the files and then do a "Save As" Excel 95/7.0, but any new features from 97 would be lost.

Is this answer helpful?
0 Yes | 0 No

213 views

More Questions for you:

My question is when your working with multiple worksheets how do you transfer added figures from one worksheet to another without losing the total?

I have a list of 3215 product names on a spreadsheet. Each resides in a single cell. I need to put each name in quotes. The names are all in one column?

I wish to count the number of cells in a col or row that have a value > 0. How is this done? The zero is displayed in the cells. Count() will only ignore a blank cell?

There are many monetary signs in Excel97 but I have not found one yet for the new euro currency. Any suggestions?

I am trying to get the percentage of two cells by dividing one cell into the other. Some of the time both cells might have a Zero in each. Therefore the DIV?

I am new at this Excel game. How do you figure elapsed time? I have formatted the cells in military time, create a start time column and an end time column and would like to know the difference?

I want to count the number of cells in a range that have a particular interior color. The countif function seems like the right kind of answer but how to I return the color of the interior for each cell in a range? I would like to do something like =countif(b1b10, cell("interior","Red"))?

Thanks for your great answer, but this results in my data be backwards; i.e. rather than 12345 I need it to be 54321. Any further thoughts?

I download data which comes to me in a column. I want to use it in a complex sheet that needs data in a row. How can I convert the column data into row data?

How can I enter the symbol for the new Euro currency in my spreadsheet?

rendc.org

Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."

Quick Links:

Interview Question and Answer Questions Add Questions News-Feed Add Posts HR Hacks Tutorials Profile rendc.com memeph.com

Question and Answer:

Home MS Excel

⟩ I am trying to open files called "Excel 97 Templates" with my Excel for Windows 95, Version 7.0. I get the message "(filename).xls file format is not valid". What gives? Is the "Excel 97" saved file just unreadable by my version?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links:

Question and Answer:

Home MS Excel

⟩ I am trying to open files called "Excel 97 Templates" with my Excel for Windows 95, Version 7.0. I get the message "(filename).xls file format is not valid". What gives? Is the "Excel 97" saved file just unreadable by my version?

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

BE THE FIRST TO KNOW

Quick Links: