Forum Discussion

MarcR's avatar
MarcR
VIP
3 years ago

Reducing size of the XFGetCell function

The XFGetCell function has 20 arguments, when you have a large sheet (e.g. for data validation) there can be many of these functions increasing the size of the excel file. In SmartView it was possi...
Excel Add In
  • PeterFu's avatar
    PeterFu
    3 years ago

    Hi Marc,

     

    I think you are looking for the @XFGetCellUsingScript formula. See print screen below. My formula is picking up the Cube in B1, the POV from B2, entity in A11 and time in C8.

    Peter

gbftong's avatar
gbftong
New Contributor II
2 years ago

I used this solution as well and would like to add you don't need to call out every dimension.  If you omit, I believe it behaves like QuickView and assumes the default POV.