ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Worksheet name length (https://www.excelbanter.com/excel-programming/274617-worksheet-name-length.html)

Jason[_16_]

Worksheet name length
 
Hi all,

Is there a possible way to make Excel accept worksheet name that is
more than 32 char long?

I am trying to transform XML data into XML Spreadsheet form and I have
no control on the length of certain tag in the XML that would be set as
the worksheet name. When I open the XMLSS in Excel I see the name is
truncated after 32 characters.

Any help on this will be of great use.

Regards,
J



------------------------------------------------
Message posted from the Excel Tip Forum at http://www.ExcelTip.com/forum/

-- View and post usenet messages directly from http://www.ExcelTip.com
-- Hundreds of free MS Excel tips, tricks and solutions
------------------------------------------------

Jim Rech

Worksheet name length
 
The maximum sheet name length is 31 characters and I do not there is any way
to change that, sorry.

--
Jim Rech
Excel MVP




All times are GMT +1. The time now is 08:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com