- OneStream Community
- Forums
- Reporting
- Re: XFGETCELL stuck in #REFRESH when referring to a TIME dimension that is a formula
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
XFGETCELL stuck in #REFRESH when referring to a TIME dimension that is a formula
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-25-2021
11:21 AM
- last edited on
05-24-2023
12:10 PM
by
JackLacava
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?
- Labels:
-
Excel Add In
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-26-2021 09:53 AM
I have the same issue so I would be keen for help on this too!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-30-2021 08:56 PM
could this setting in the following KB be causing this issue?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2021 03:55 PM
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.
