Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Why is MS Excel renaming worksheets (truncating names)? Is there a fix for this?
Why is MS Excel renaming worksheets (truncating names)? Is there a fix for
this? Why is Excel renaming worksheets? Is there a fix for this? I am seeing something very strange with some Office-2003 Excel spreadsheets I am trying to manipulate. My spreadsheets contain many sheets (tabs), many with long names (e.g. 44 characters). When I make copies of these spreadsheets the names of some of the sheets get changed, i.e. truncated (e.g. down to 31 characters). This is a problem for me because QTP is using the names of the sheets to parse data. Are you aware of any issues in Excel which might cause something like this? The issue has only become apparent recently, spreadsheets created last year did not suffer from this problem. Maybe it was introduced by a recent service pack to Office-2003? Exploration: I installed OPENOFFICE 2.2 on my machine. This a free counterpart of Microsoft office, available from http://www.openoffice.org When I manipulate spreadsheets in OpenOffice, the sheet name is preserved. When I exit Excel after opening a spreadsheet saved in OpenOffice, Excel asks me if I want to save it in the "new" Excel format .. Of course the correct answer is "no". However When I launch QTP using a spreadsheet saved in Openoffice, Excel interrupts the QTP test and asks to resave the file in the new format. When I click "no", the test then hangs. So I still do not have a solution to the problem. Or does Microsoft have a fix for this? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Why is MS Excel renaming worksheets (truncating names)? Is there afix 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? Why is Excel renaming worksheets? Is there a fix for this? I am seeing something very strange with some Office-2003 Excel spreadsheets I am trying to manipulate. My spreadsheets contain many sheets (tabs), many with long names (e.g. 44 characters). When I make copies of these spreadsheets the names of some of the sheets get changed, i.e. truncated (e.g. down to 31 characters). This is a problem for me because QTP is using the names of the sheets to parse data. Are you aware of any issues in Excel which might cause something like this? The issue has only become apparent recently, spreadsheets created last year did not suffer from this problem. Maybe it was introduced by a recent service pack to Office-2003? Exploration: I installed OPENOFFICE 2.2 on my machine. This a free counterpart of Microsoft office, available from http://www.openoffice.org When I manipulate spreadsheets in OpenOffice, the sheet name is preserved. When I exit Excel after opening a spreadsheet saved in OpenOffice, Excel asks me if I want to save it in the "new" Excel format .. Of course the correct answer is "no". However When I launch QTP using a spreadsheet saved in Openoffice, Excel interrupts the QTP test and asks to resave the file in the new format. When I click "no", the test then hangs. So I still do not have a solution to the problem. Or does Microsoft have a fix for this? -- Dave Peterson |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Why is MS Excel renaming worksheets (truncating names)? Is there a fix for this?
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? |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
Why is MS Excel renaming worksheets (truncating names)? Is there a fix for this?
Hi Charles
Don't see how you achieved that. this is a very long sheet name! is 31 characters and is the most I can enter in any sheet in any version of Excel including XL2007 -- Regards Roger Govier "Charles F. Radley" wrote in message ... 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? |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
Why is MS Excel renaming worksheets (truncating names)? Is there afix for this?
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 |
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.setup
|
|||
|
|||
Why is MS Excel renaming worksheets (truncating names)? Is there afix for this?
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 |
#8
Posted to microsoft.public.excel.setup
|
|||
|
|||
Why is MS Excel renaming worksheets (truncating names)? Is there a fix for this?
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 |
#9
Posted to microsoft.public.excel.setup
|
|||
|
|||
Why is MS Excel renaming worksheets (truncating names)? Is therea fix for this?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Renaming worksheets | Excel Discussion (Misc queries) | |||
Renaming scan files with a list of drawing names in excel spreadsh | Excel Discussion (Misc queries) | |||
Renaming worksheets | Excel Discussion (Misc queries) | |||
Batch renaming of many worksheets in Excel files? | Excel Discussion (Misc queries) | |||
Putting Sheet Names in a range and renaming it? | Excel Worksheet Functions |