Thursday, January 05, 2006

Data Validation Lists

If you use Data Validation Lists in your TM1 Excel reports you may have tried setting the list to refer to cells that are not contained in the worksheet that you want the validation list to appear in. In fact when you try to navigate to a different worksheet Excel just refuses to do anything.

You can though get the Data Validation List to use cells on a different worksheet by giving them a Range name and then setting the source to be equal to that Range name. This way you can just have one worksheet to contain all of your lookup values.