Forum Discussion

ignacex's avatar
ignacex
New Contributor
4 years ago

XFGETCELL stuck in #REFRESH when referring to a TIME dimension that is a formula

When I use a formula to set-up the time member, the XFGETCELL formula that refers to this time member is stuck in #REFRESH. The weird thing is, if I go in the XFGETCELL formula and hit enter without ...
Excel Add In
  • ignacex's avatar
    ignacex
    New Contributor
    4 years ago

    We've tried playing around with that setting, when it is false and we open the file, the values are there, but the moment we click refresh, the value changes to #REFRESH and there does not seem to be a way to get it back except to go into the formula and hit enter. If the value is TRUE, it starts off as #REFRESH and does not change even after we click refresh, so it does not seem to be related to our issue.