Skip to main content
N
Nirmal_Daswani
Newcomer
December 8, 2022

XFSetCell REFRESH requirement

  • December 8, 2022
  • 2 replies
  • 0 views

Is there a setting or option wherein users don’t have to refresh the XFSetCell based excel reports every time the file is opened?

    2 replies

    B
    BobMarchese
    Newcomer
    December 8, 2022

    Have you tried changing the Administration - Preferences setting for "Invalidate Old Data When WorkBook Is Opened" from True to False?

      H
      OneStream Employee
      HenningOneStream Employee
      OneStream Employee
      December 9, 2022

      Adding a screenshot for more clarity:

       

      Henning_0-1670574097276.png

       

       

      N
      Nirmal_DaswaniAuthor
      Newcomer
      January 10, 2023

      Yes. That setting is set to False. I believe it only applies to QuickView and not XFGetCell. OS Support asked us to raise an enhancement in Ideastream

      H
      OneStream Employee
      HenningOneStream Employee
      OneStream Employee
      January 11, 2023

      Hi, I just tested it again to make sure. This setting applies to Quick Views as well as XFGetCell in Excel. I am on version 7.1.1. Maybe you are using some references in the formulas that break it? Not sure how far you have tested this, but I recommend testing this with the most simple set up first and then work your way up to where you are now to determine where the error may be.

      V
      Vincent
      Newcomer
      January 18, 2023

      I had the same issue and setting "Invalidate Old Data ...." to false allow me to have my last data retrieve when I open my file.

      But I still have an issue :  my tab have some collapsed colums and rows and when I Ungroup it the #REFRESH appears.

      The only way I founds is to desactivate automatic calculation in excel and have a new habit clicking on F9 to calculatre manually. (I don't know if we can add something in a xl formula to make the cell not be refreshed automatically)

       

      But totally agree that we need an enhancement.

        Terms & ConditionsAccessibility statement