So this is kind of an interesting one for me...
Essentially I have some cells which have data validation referencing a named range. The named range is on another worksheet and consists of Cube Members. I have a bunch of cube functions which reference the selected cube member from the data...