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.

--
Regards
Rob

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.
--
Regards
Rob

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.

--
Regards
Rob
"Jim Cone" wrote in message
...


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.
--
Regards
Rob

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" wrote in message
...
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.

--
Regards
Rob
"Jim Cone" wrote in message
...


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.
--
Regards
Rob

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

--
Regards
Rob
"Ron Coderre" wrote in message
...
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" wrote in message ...
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.

--
Regards
Rob
"Jim Cone" wrote in message
...


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.
--
Regards
Rob