SAC Excel Addin - Formula Error

[anantbavadiya]

Hi SAC Community, 

We have designed SAC Budget Input templates on SAC Excel Addin (with similar approach of what SAP BPC EPM Excel used to do).

With this Budget data input template, user selects required entity and budget version based on SAC formula =SAP.GETDIMENSIONFILTER("Table2","Company_Code")

This formula works fine for all users but the same formula gets converted to (becomes dummy function for excel as it can not read the formula ) following =_xldudf_SAP_GETDIMENSIONFILTER("Table2","Company_Code") for few users (all users have same SAC access profile / role with Excel addin READ, WRITE, DELETE)

Please reply if similar/same issue faced by any of you and have a resolution for it. 

Thank you.   

[AkshatM]

Reinstalling Excel-addin worked for me

[anantbavadiya]

Root cause - SAC Add-in formulas were not recognized by Excel, due to this excel functions turns to xludf.dummyfuntion. 

Solution - Disable or uninstall SAC Excel add-in and enable or re-install. Excel will start recognizing SAC formulas. 

Thank you @AkshatM for input, it helped.