Skip to main content
Member
Dec 8, 2022 3:31 PM UTC

XFSetCell REFRESH requirement

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

5 replies

Newcomer
Dec 8, 2022 7:20 PM UTC

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

Employee - Advisor
Dec 9, 2022 8:20 AM UTC

Adding a screenshot for more clarity:

 

Henning_0-1670574097276.png

 

 

Member
Jan 10, 2023 5:18 PM UTC

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

Employee - Advisor
Jan 11, 2023 10:37 AM UTC

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.

Newcomer
Jan 18, 2023 7:59 AM UTC

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.