This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
Excel worksheet name won't go beyond 31 characters
Autor wątku: Steven Smith
Steven Smith Wielka Brytania Local time: 22:48 Członek ProZ.com od 2007 japoński > angielski
Dec 9, 2006
I'm sure it must be possible to increase the length of the worksheet name in Excel (2003) beyond 31 characters but I can't find out how to do it. Can anyone tell me?
Thanks
Steven Smith
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
mjbjosh Local time: 23:48 angielski > łotewski + ...
Directory problem?
Dec 9, 2006
What O/S do you use? I think Windows allows something like 264 characters in the filename. You have to remember that filename includes the directory path.
Your directory path probably looks similar to this:
C:\Documents and Settings\John Doe\My Documents\Company XXX\Projext YYY\Source Texts\etc....
The path name alone can have more than 200 characters, so that's why you can use only 31 chars for the file name itself. If you moved the file to C:\ or a direct... See more
What O/S do you use? I think Windows allows something like 264 characters in the filename. You have to remember that filename includes the directory path.
Your directory path probably looks similar to this:
C:\Documents and Settings\John Doe\My Documents\Company XXX\Projext YYY\Source Texts\etc....
The path name alone can have more than 200 characters, so that's why you can use only 31 chars for the file name itself. If you moved the file to C:\ or a directory with a shorter path name, you could most probably select a longer filename.
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Steven Smith Wielka Brytania Local time: 22:48 Członek ProZ.com od 2007 japoński > angielski
NOWY TEMAT
Maybe I misled you
Dec 9, 2006
Sorry, I mean the worksheet title as it appears on the tab at the bottom of the worksheet. I have multiple worksheets in a workbook and I need to change their names, but when I try this using 'rename' I can't get past 31 characters.
Steven
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Antonín Otáhal Local time: 23:48 Członek ProZ.com od 2005 angielski > czeski + ...
no go
Dec 9, 2006
AFAIK, 31 is really the maximum length of a worksheet name.
Antonin
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
William [Bill] Gray Norwegia Local time: 23:48 Członek ProZ.com od 2006 angielski + ...
No go, Steven...
Dec 10, 2006
Here is a link which agrees with Antonin.
But wait a few years, and it will probably change!!
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Oliver Walter Wielka Brytania Local time: 22:48 niemiecki > angielski + ...
Why 31
Sep 6, 2014
I imagine the limit is 31 because (a) the designers who specified this number thought that most worksheet names would probably be up to about 8 or perhaps 12 characters but they should allow longer ones, and (b) 31 is the largest number that can be represented in a 5-bit data field (e.g. 00000 is zero, 00101 is five, 11111 is 31) and 5 bits was a convenient size for the field (within the data structure that defines a spreadsheet) that tells Excel the number of characters in this name... See more
I imagine the limit is 31 because (a) the designers who specified this number thought that most worksheet names would probably be up to about 8 or perhaps 12 characters but they should allow longer ones, and (b) 31 is the largest number that can be represented in a 5-bit data field (e.g. 00000 is zero, 00101 is five, 11111 is 31) and 5 bits was a convenient size for the field (within the data structure that defines a spreadsheet) that tells Excel the number of characters in this name. Oliver ▲ Collapse
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Translate faster & easier, using a sophisticated CAT tool built by a translator / developer.
Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools.
Download and start using CafeTran Espresso -- for free
The leading translation software used by over 270,000 translators.
Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop
and cloud solution, empowering you to work in the most efficient and cost-effective way.