Linking BPC input schedules to external spreadsheets

[Former Member]

Does anyone know the workaround to link an input cell in an input schedule to an external spreadsheet cell and the formula stays there after save?

[Former Member]

Hi,

I have never tried this, but I think this should be feasible. But need to remember 2 things.

1. The link to the external file should be properly quantified. So that the file is accessible from all the client systems.

2. The link should be in a static cell. If the cell is under the dynamic expansion, then the link will be overwritten after expansion.

Hope this helps.

[Former Member]

? What I mean is, I want go to a cell and go =Sheet2:F16. At the moment, once I save, the formula dissappears. Will you solution solve that?

[Former Member]

Hi,

Yes, you can use similar formula for referencing values from another spreadsheet. However, as I have mentioned in my previous reply, if this cell is under dynamic expansion, then the formula will be lost.

Hope this helps.

[former_member186338]

Static means that in the EVDRE formula instead of:

=EVDRE (AppName, Key range, Expand range)

You have:

=EVDRE (AppName, Key range)