Forum Discussion

Jacky_C's avatar
Jacky_C
New Contributor III
3 months ago

Unable to retrieve data through XFGet formula

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 al...
Excel Add In
MG's avatar
MG
Community Manager
3 months ago

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.  

  • Jacky_C's avatar
    Jacky_C
    New Contributor III
    3 months ago

    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.