What is an Excel 2.1 Worksheet?

[RobWN]

I received a workbook that had some formatting problems, which I fixed but, when I went to save
it I got a message that it was an Excel 2.1 worksheet.
I saved it using the overwrite option.
All is well but I was wondering what this is and if the formatting problem (rows appeared
wrapped and unaligned with the column headings) could be related to the 2.1 format, or just a
mixed up user ("PIBCAK").

We expect to receive these workbooks (10+) on a monthly basis and if it's the user then we can
have them fix it, if it's the app that prepares them then I'll have to set up a macro to fix the
workbooks.

 

[Jim Cone]

This says it is the second Excel version that MS released and it is 20 years old...
http://j-walk.com/ss/excel/index.htm
Why not ask the sender about it?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"RobWN"
wrote in message
I received a workbook that had some formatting problems, which I fixed but, when I went to save
it I got a message that it was an Excel 2.1 worksheet.
I saved it using the overwrite option.
All is well but I was wondering what this is and if the formatting problem (rows appeared
wrapped and unaligned with the column headings) could be related to the 2.1 format, or just a
mixed up user ("PIBCAK").

We expect to receive these workbooks (10+) on a monthly basis and if it's the user then we can
have them fix it, if it's the app that prepares them then I'll have to set up a macro to fix the
workbooks.

 

[RobWN]

Thanks Jim;

I would except it's Saturday night and I'm just starting to work on it (I don't have much of a
life!).
This is a business application.

I don't think the reference is to the Excel version but, rather, to an application that writes
xl worksheets.
Googling gives me a raft of download sites with references to "Business Tools" (not a simple
"what is")

I was hoping someone familiar with the app could answer my question, is it the app or the
user(?).

Again, thanks for your reply.

 

[Ron Coderre]

Many business apps are able to export data or reports to an Excel file. To
be "safe", they export an Excel version that is so old that virtually
anybody with Excel will be able to open it. You don't mention the
application, but it can probably export in various Excel formats along with
CSV and tab delimited files. Next chance you get, see if they can provide a
format from this century.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[RobWN]

Ron;

It certainly helps.

I'm aware of the use of an older version - our I-Series Navigator transfer utility has xl ver 8
as its highest version, in addition to CSV etc.

I was just taken aback by the version being so old and being expressed with a decimal- pre-dates
my earliest exposure to xl 97 (V8).

Thankfully the format-as screwed up as it is (which caused me to wonder if it was the app or
user)-is consistent, so I've written a macro to process the workbooks.


Thanks for confirming the problem.
Regards
Bob