Hi All,I've prepared a large report on Excel that contains over 30 tabs and all pulling data from OS using XFGetCell formulae. However, recently the issue we are having is that when we "Refresh Workbook" the formulae disappear for the entire workbook...
Hi Community !Is there a way to get the culture of the user, by using a retrieve function like XFGetCell?Basically, I have to retrieve the user culture in an Excel file in order to define Titles and other periferical elements in the spreadsheet.Regar...
How can I get xfgetcell formula to not pull in the next month as a negative? i am making a YTD file and currently have Jan and Feb number but march pulls in the YTD amount but negative and causes the ytd amount to be $0.
Is there a way to use functions as parameters in an XFGetCell formula? I want to retrieve values for the previous month to compare to the actual month. It would be nice to use something like T#MonthPrior1([actual month]) instead of using some excel f...
When I use a formula to set-up the time member, the XFGETCELL formula that refers to this time member is stuck in #REFRESH. The weird thing is, if I go in the XFGETCELL formula and hit enter without changing anything, when I refresh the sheet it work...
