Showing results for 
Search instead for 
Did you mean: 

EVDRE Input Schedule - shifting of cells/formulas

Former Member
0 Kudos

Hi everybody,

I am using BPC version 5.1. I do have a problem with an EVDRE Input Schedule. It is a single EVDRE report which is nested with a product and an account dimension.

Underneath the Data Input Range, I have written additional information and included a button with the send function. If I change the selected product members through another button which is above the input range and expand the report, the additional information and the button always move one row up when expanding.

Has anybody experienced a similar problem or has a solution for the problem? I am happy to provide additional information.

On top of that problem I do have cell reference sin formulas that also change when expanding. I e.g. have a EVPROP formula that shifts the row in the reference one row up each time I expand. The formula is on the left side of the input range next to the row IDs. I don't know why, but this problem doesn't occur on all input schedules.

Does anybody have a clue how to solve the issue?

Thank you very much in advance!


Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello experts,

I've got another similar problem:

I do have shapes in an Excel Input Schedule, as well as drop downs, both with assigned macros. I don't know why, but some of them (not always the same) disappear.

I have no idea how that happens or where the shapes are now.

Does anybody have a clue?

Thanks in advance!