A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Older excel won't open spread sheet



 
 
Thread Tools Display Modes
  #1  
Old October 24th, 2003, 07:55 PM
Steve
external usenet poster
 
Posts: n/a
Default Older excel won't open spread sheet

Hello,

I created a spread sheet at home with Excel XP or 2000
(not sure what its called) and e-mailed it to myself at
work. We have an ancient version of Excel on Win 98 at
work, ver 5.0a. When I try to open the spread sheet it
says it is not a valid Excel format. It has an '.xls after
the name of the file. Isn't that a valid format??

Please Help!!
  #2  
Old October 24th, 2003, 08:05 PM
Chip Pearson
external usenet poster
 
Posts: n/a
Default Older excel won't open spread sheet

Steve,

Excel version 5 uses a file format called BIFF5, and Excel 97/2000/2002/2003
uses a file format called BIFF8. Excel 5 cannot open BIFF8 files, which is
why you get the "invalid file format" message, even though both file formats
use the "xls" file extension.

You can, in later versions of Excel, store the file in the earlier format
when you do a Save As, that will allow Excel 5 to open the file. In the
Save As dialog, change "Save As Type" to "Excel 97 & 5/95 Workbook". Of
course, you won't be able to access newer features in the earlier version.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Steve" wrote in message
...
Hello,

I created a spread sheet at home with Excel XP or 2000
(not sure what its called) and e-mailed it to myself at
work. We have an ancient version of Excel on Win 98 at
work, ver 5.0a. When I try to open the spread sheet it
says it is not a valid Excel format. It has an '.xls after
the name of the file. Isn't that a valid format??

Please Help!!



  #3  
Old October 26th, 2003, 01:30 AM
Kim Mitchell
external usenet poster
 
Posts: n/a
Default Older excel won't open spread sheet

You can get a free Excel viewer from Microsoft. I do not know if it will
allow you to copy/paste what you view to your version of Excel.

Kim

"Steve" wrote in message
...
Hello,

I created a spread sheet at home with Excel XP or 2000
(not sure what its called) and e-mailed it to myself at
work. We have an ancient version of Excel on Win 98 at
work, ver 5.0a. When I try to open the spread sheet it
says it is not a valid Excel format. It has an '.xls after
the name of the file. Isn't that a valid format??

Please Help!!



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.