I have a VBA function that takes a named range as an input. The range
contains formulas with links to real-time fields. In the first line of
the function, I pull out the values field of the range: x =
InputX.Values (or x = InputX.Values2; both produce the same problem).
Usually this returns a Variant with the values in the range, but
occasionally it returns a Variant with empties in all the fields. Any
ideas what's causing this and how to prevent it?

Thanks,
Marc