Hey,
I'm using the following formula =INDIRECT("[book2]Sheet1!D6") to create a drop list to an external master file that contains a long list of names, departments, rates etc...
I'm about to roll this out to the users on several files.
However it only works some of the time. Other times when I click on the drop down box the list does not appear. (This is nothing to do with the sorting of the list
)
Does anyone know why it only work some of the times?
Thanks
I'm using the following formula =INDIRECT("[book2]Sheet1!D6") to create a drop list to an external master file that contains a long list of names, departments, rates etc...
I'm about to roll this out to the users on several files.
However it only works some of the time. Other times when I click on the drop down box the list does not appear. (This is nothing to do with the sorting of the list
)Does anyone know why it only work some of the times?
Thanks
