Can you remove any proprietary information from that workbook, zip it and send
it to me.

I'd like to see it.

And I think that there are lots of programs that create native .xls files. I
don't have a list, but I know that Crystal Reports is one.

And I didn't mean to suggest that CR is an alternative to excel. I meant that
there are other programs that create those binary .xls files directly. Just so
that you can easily transfer data from the other source to excel using one of
these programs.



"Charles F. Radley" wrote:

Hi Dave,

It is not a question of mis-remembering.

The worksheet is open in front of me right now, and there are tab names with
44 characters, 38 characters ,etc.

I am not hallucintating, this is real.

If the sheets were not created in Excel, can you offer ideas on how they
were created? I would gladly try a different tool.

I have tried Openoffice, but that does not solve the problem.

I do not believe we have Crystal reports here, but I can look into it if
you think that is a viable alternative.

Thanks.

"Dave Peterson" wrote in message
...
I think you're miss-remembering the number of characters in the sheet name
if
the files were created directly in excel.

But IIRC, there are other programs that can make .xls workbooks with
invalid
sheet names.

I kind of remember seeing posts that complain about Crystal Reports (or
some
other program???) doing this--and when the workbook was opened, the user
was
told that the invalid sheet name was changed. (But I could be wrong about
this
memory!)

"Charles F. Radley" wrote:

These are Excel files.

The person who originally created them has left the company.

Until recently they were working fine.

"Dave Peterson" wrote in message
...
I guessed (incorrectly) at QTP.

You sure you used excel to create these workbooks with the worksheets
with
the
long names?

"Charles F. Radley" wrote:

Greetings Dave,

Until recently we routinely used sheet names of up to 44 characters
without
difficulty.

QTP = Quick Test Pro (from Mercury Interactive), is automated test
harness.

Thanks,

Charles R.

----- Original Message -----
From: "Dave Peterson"
Newsgroups: microsoft.public.excel.setup
Sent: Wednesday, June 13, 2007 2:57 PM
Subject: Why is MS Excel renaming worksheets (truncating names)?
Is
there a fix for this?

There is a limit of 31 characters per sheet name in excel.

It's been that way for as long as I can remember (xl95 at least).

I don't use openoffice or Quatro Pro, but I don't understand how
excel
can
interrupt Quatro Pro after you've launched that program, then done
file|open to
open your workbook.



"Charles F. Radley" wrote:

Why is MS Excel renaming worksheets (truncating names)? Is there a
fix
for
this?

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson