Forum Discussion
Why doesn't the spilled range operator work?
Dynamic arrays seem to have been working on all our office PCs for a couple of weeks and formulas are spilling as expected, but if we try to use the spilled range operator in a reference (like $A2#) we get a #REF error. We're on the Monthly channel. Is it working for anyone else on the Monthly channel?
11 Replies
Yes, monthly channel shall be covered by dynamic array functionality.
Typing such reference do you see the source spill selected?
No, I get a #REF error.
But Dynamic Arrays are working because they spill if I do something like =$A2:$A11
- This is what I am trying to achieve, and how I interpreted the doco. What did you end up doing?
