Programming error in Danish Excel for lists sourced by table names

%3CLINGO-SUB%20id%3D%22lingo-sub-3514511%22%20slang%3D%22en-US%22%3EProgramming%20error%20in%20Danish%20Excel%20for%20lists%20sourced%20by%20table%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3514511%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EThis%20error%20might%20only%20be%20relevant%20for%20the%20Danish%20languaged%20version%20of%20Excel%20(Microsoft%20365%20version%2C%20fully%20updated).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20make%20a%20list%20(drop%20down)%20in%20a%20cell%2C%20and%20I%20set%20the%20source%20to%20a%20named%20table%20(e.g.%20%3DNameOfTable)%2C%20Excel%20correctly%20finds%20the%20table%20and%20mark%20the%20relevant%20cells%2Fvalues%20of%20said%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20I%20cannot%20press%20%22OK%22%20and%20actually%20select%20the%20source%2C%20as%20the%20%22There%20is%20a%20problem%20with%20this%20formula%22%20pops%20up.%20This%20is%20clearly%20an%20error%2C%20as%20even%20the%20Danish%20translated%20guides%20from%20Microsoft%20show%20that%20same%20syntax.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20how%20else%20to%20get%20this%20to%20Microsoft.%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EMartin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3514511%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3515023%22%20slang%3D%22en-US%22%3ERe%3A%20Programming%20error%20in%20Danish%20Excel%20for%20lists%20sourced%20by%20table%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3515023%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1426076%22%20target%3D%22_blank%22%3E%40MFadmin%3C%2FA%3E%26nbsp%3BYou%20can't%20use%20table%20references%20in%20data%20validation.%20Nothing%20to%20do%20with%20Danish%20language.%20In%20the%20List%20box%20you%20can%20reference%20a%20named%20ranges%2C%20a%20dynamic%20array%2C%20a%20regular%20range%20or%20you%20type%20all%20the%20options%20in%20the%20box.But%20table%20references%20are%20not%20allowed.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi

This error might only be relevant for the Danish languaged version of Excel (Microsoft 365 version, fully updated).

 

When I make a list (drop down) in a cell, and I set the source to a named table (e.g. =NameOfTable), Excel correctly finds the table and mark the relevant cells/values of said table.

 

However, I cannot press "OK" and actually select the source, as the "There is a problem with this formula" pops up. This is clearly an error, as even the Danish translated guides from Microsoft show that same syntax.

 

Not sure how else to get this to Microsoft.

Thank you

Martin

1 Reply

@MFadmin You can't use table references in data validation. Nothing to do with Danish language. In the List box you can reference a named ranges, a dynamic array, a regular range or you type all the options in the box.But table references are not allowed.