SOLVED

Excel Dependent Data Validation tables naming convention -

%3CLINGO-SUB%20id%3D%22lingo-sub-1974524%22%20slang%3D%22en-US%22%3EExcel%20Dependent%20Data%20Validation%20tables%20naming%20convention%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1974524%22%20slang%3D%22en-US%22%3E%3CP%3ELooks%20like%20the%20Excel%20table%20naming%20convention%20for%20dependent%20data%20validation%2C%20requires%20the%20table%20name%20to%20not%20have%20any%20spaces%20and%20the%20only%20special%20characters%20allowed%20are%20underscore%20_%20and%20the%20period.%26nbsp%3B%20Is%20this%20correct%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1974524%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1974960%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dependent%20Data%20Validation%20tables%20naming%20convention%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1974960%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F896363%22%20target%3D%22_blank%22%3E%40Marshall0901%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes.%20See%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Frename-an-excel-table-fbf49a4f-82a3-43eb-8ba2-44d21233b114%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ERename%20an%20Excel%20table%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1975034%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dependent%20Data%20Validation%20tables%20naming%20convention%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1975034%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F896363%22%20target%3D%22_blank%22%3E%40Marshall0901%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBroadly%2C%20what%20you%20say%20about%20the%20naming%20convention%20for%20defined%20names%20is%20correct%2C%20but%20don't%20forget%20that%20what%20you%20think%20of%20as%20a%20letter%20or%20the%20alphabet%20and%20what%20the%20average%20Greek%20may%20consider%20to%20be%20a%20letter%20might%20differ.%26nbsp%3B%20In%20practice%2C%20many%20Unicode%20characters%20also%20work%20within%20names.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EThus%2C%20should%20you%20choose%2C%20you%20could%20name%20a%20Table%20or%20a%20formula%3C%2FP%3E%3CP%3E%E2%86%90%CE%9B%C2%B3%E2%88%95%3C%2FP%3E%3CP%3Eand%20it%20will%20work.%3C%2FP%3E%3CP%3ENote%3A%20The%26nbsp%3B%E2%88%95%20is%20fraction%20separator%2C%20not%20the%20ASCII%20slash%20operator.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1977209%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dependent%20Data%20Validation%20tables%20naming%20convention%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1977209%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20Peter.%26nbsp%3B%20Your%20response%20is%20very%20helpful.%26nbsp%3B%20Have%20a%20safe%20%26amp%3B%20great%20weekend.%3C%2FP%3E%3CP%3EBest%20Regards%2C%3C%2FP%3E%3CP%3EMarshall%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Looks like the Excel table naming convention for dependent data validation, requires the table name to not have any spaces and the only special characters allowed are underscore _ and the period.  Is this correct?

4 Replies
Best Response confirmed by Marshall0901 (Occasional Contributor)

@Marshall0901 

Broadly, what you say about the naming convention for defined names is correct, but don't forget that what you think of as a letter or the alphabet and what the average Greek may consider to be a letter might differ.  In practice, many Unicode characters also work within names.  

Thus, should you choose, you could name a Table or a formula

←Λ³∕

and it will work.

Note: The ∕ is fraction separator, not the ASCII slash operator.

@Peter Bartholomew 

Thank you Peter.  Your response is very helpful.  Have a safe & great weekend.

Best Regards,

Marshall

@Hans Vogelaar 

Thank you Hans,

Your response is truly appreciated and very helpful.  Have a safe and fun weekend.

Best Regards,

Marshall