Hello,

I use Sap Business Objects Financial Consolidation (BFC or previously Magnitude) excel add-in for reporting. The excel add-in uses custom functions like GetCtData and GetCtLabel for pulling data out from the database.
The issue is that the custom function is only available on PC's where the excel addin is installed. In case a report is sent to a user without this addin then the values in the report are shown as "#NAME?" instead of the real value.
Option a, is to remove all these functions on a PC where the addin is installed and replace the cell contents with value. There is a working solution for this in the form of a VBA code.
What I am looking for is option b, a custom function which then would enable the users to open the BFC files in "normal" excel without any problems.
The syntax of the function is something like:

=GetCtData("COAMOUNT","CONSAMOUNT",U$4:U$10,$B16:$D16,"#33535.6942644545")

In an excel where the addin is installed the cell is displayed as 33535.6942644545, I would like to reach the same in excels where the addin is not installed through a custom function.

Any suggestion?
Many thanks!