Questions about Cube Views and Reports
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Issue with XFGetCell disappearing upon refresh

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

Zarar by New Contributor
  • 1 replies
  • 0 kudos

User Culture using Retrieve Function like XFGetCell ?

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

Sergey by Contributor
  • 0 replies
  • 0 kudos

XFgetcell pulls in future months as YTD negative

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.

Resolved! Is there a way to use functions as parameters in XFGetCell?

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

LindaJ by New Contributor
  • 2 replies
  • 0 kudos