Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

RE: Structural Engineering Spreadsheets - new Excel Version with XLSX!

[Subject Prev][Subject Next][Thread Prev][Thread Next]
There are two ways you can deal with the new file format. You can force Excel 2007 to save to files to the old file format, or you can download the Microsoft Compatibility Pack at . It allows Excel 2003 and XP to work with the new file format.

Wesley C. Werner


From: Neil Moore [mailto:nma(--nospam--at)]
Sent: Tuesday, November 06, 2007 11:07 AM
To: seaint(--nospam--at)
Subject: RE: Structural Engineering Spreadsheets - new Excel Version with XLSX!

Yes, you are correct, Tom.

But problem is that many don't have Excel 2007 and the previous versions won't open up the new version.   We do all our calculations on the screen and with various offices work back and forth - not all with Excel 2007.

Reminds me of the time I took VB at the local college.   The college's version that the teacher was using was V4.   The program being sold at the bookstore was V5 and the two weren't compatible and became a homework nightmare.


At 07:35 AM 11/6/2007, you wrote:
Old versions of XLS worksheets indeed work in Excel 2007.  Until our office completely changes over to Excel 2007, we are still saving workbooks in XLS format.  From what I understand, the XLSX format is a “zipped” version of XLS, so the file size is much more reasonable.
I’ve been on either Beta or Excel 2007 for over a year now.  Generally I like it, but have found some weird quirks (or shall I call them features) with the new version.  And, have found some number crunching programs (typically two dimension matrices) written with the old visual basic to run significantly slower in the new version.  IN some cases, Excel 2000 will crunch the numbers is less than 1 minute, Excel 2007 in +1 hr…
Thomas D. Skaggs, Ph.D., P.E.
Manager, Product Evaluation
Technical Services Division
APA - The Engineered Wood Association
7011 S. 19th Street
Tacoma, WA 98466
ph: 253/565-6600
fx: 253/620-7235
From: Neil Moore [ mailto:nma(--nospam--at)]
Sent: Tuesday, November 06, 2007 07:19
To: seaint(--nospam--at); seaint(--nospam--at)
Subject: Re: Structural Engineering Spreadsheets - new Excel Version with XLSX!
Speaking of Excel spreadsheets:

Are many of you having problems with running XLS and XLSX files?

Apparently the older versions will not open this new version (Excel 2007).

Neil Moore, SE, SECB
neil moore and associates
consulting structural engineers
shingle springs, california

Distressed Structures Investigations