#6 shape naming fails because of name length exceeding limit

closed-out-of-date
nobody
None
5
2010-01-20
2009-01-15
nixnut
No

# David Vize "Did you realise that the shape naming process does not always work? I found that the text was too long (long page names). thought you might like to know"

# Fabrice "Thanks for your input David. I put this on the bug list."

I've seen this as well. In excel2000 the maximum name length is 31 characters. The maximum length of a worksheet is also 31 characters. So using the sheet name in the shape name can easily fail. It's possible that some characters in the sheet name could also cause the naming to fail. I've not tested this yet. I also don't know if the limits changed with excel2003.

Discussion

    • status: open --> closed-out-of-date