Skip to main content
I
ignacex
Newcomer
November 25, 2021

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

  • November 25, 2021
  • 3 replies
  • 0 views

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 changing anything, when I refresh the sheet it works and gets a value, but next time I close excel, re-open, re-connect and refresh it's stuck once again in #REFRESH. If I hardcode the time I don't have this issue, or if I concatenate to a hardcoded number, it also works.

As an example I have a list of 12 rows with numbers across 30 or so columns and a total at the end. The rows represents each month, so to get the last current month with numbers I use a formula (example countif) on the total column and then concatenate this to the year, so if I have data until October, I would get 10, so the formula returns 2021M10 for the current year and 2020M10 for the prior year.

Is this an issue with the add-in itself where it is confused on the order the excel formulas are being calculated?

3 replies

S
s_t
Newcomer
November 26, 2021

I have the same issue so I would be keen for help on this too!

    J
    JamesKirkby
    Newcomer
    December 1, 2021

    could this setting in the following KB be causing this issue?

     

    https://onestreamsoftware.service-now.com/sp/?sys_kb_id=53d8d0761bb57050bc19da4cbc4bcb79&id=kb_article_view&sysparm_rank=5&sysparm_tsqueryId=b7f4bcdf1b40c910d238b8c2cc4bcbc2

     

      I
      ignacexAuthor
      Newcomer
      December 1, 2021

      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.

        J
        Jmorgan
        Newcomer
        January 27, 2025

        The link to the solution no longer works, can anyone explain a solution for this issue?

        Terms & ConditionsAccessibility statement