Why is MS Excel renaming worksheets (truncating names)? Is there a fix for this?
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
|