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
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.
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.
