Skip to main content
J
Jacky_C
November 26, 2024

Unable to retrieve data through XFGet formula

  • November 26, 2024
  • 1 reply
  • 0 views

Hi all,

We have built a excel report which includes multiple xfget formulas. However, an #Value error shown in the cell after refresh (refresh sheet/refresh workbook both are not working). I have also checked that the dimensions have been entered correctly in the formula.

May I know is there any solution to address this issue?

Thank you.

Best,

Jacky

1 reply

M
MG8
November 26, 2024

Hi, The #value is a pretty generic excel error. It is difficult to to troubleshoot without looking at the file. You may get some replies but it may be better to raise a support ticket so that someone can look at your screen with you and see the details of the issue.  

J
Jacky_CAuthor
November 26, 2024

Hi MG,

Thank you for reply. I have noticed that the cell shows #REFRESH even when I have clicked both "Refresh sheet" and "Refresh workbook".  Hence it leads to the #value error in the excel.


Jacky_C_0-1732634335835.png

 

Terms & ConditionsAccessibility statement