Uncommon issue with SAP 7.5 MS formulas in Excel

[Former Member]

Dear experts:

I hope you are well. I'm reaching you because I'm having an exceptional issue with SAP BPC 7.5 MS for excel.

When I open one of my excel workbooks for first time, it will show mistaken results in some cells. When I hit the "expand all" button, the values will be corrected. This happens every time I open the workbook. I will show you some screenshots so you can manage to understand the mechanics involved and, maybe, help me with a solution:

01. The Percentages in may 2016 should be 0%, but it shows something wrong:

02. I hit the expand all button

03. The percentages start showing the right values (which is 0% for May 2016)

As always, thanks a lot in advance for your time.

Regards

José Luis Martínez

[Former Member · Accepted solution]

Hi Jose Luis,

the excel formula refers to cells of another pages, what contains these cells?

If the cells are filled with result values of ev functions then this is the cause of your issue.

Regards

     Roberto

[Former Member · Accepted solution]

Roberto:

Thanks a lot for your time. Every cell in every worksheet of that application is filled with one or multiples EVGET, and that collumn is the only one bringing those strange values.

[Former Member · Accepted solution]

try to save again the workbook after refresh, when it shows zero values.

If you open it next time is it ok?

[Former Member · Accepted solution]

Roberto:

Thanks a lot for your advice, but I believe I don't understand you. When I save the excel sheet, it saves locally, not in the server. That won't fix the problem for every division (which have unique users each). I've tried to do a Send after the fix, and that didn't fix the problem.

Thanks a lot for your help.

[Former Member · Accepted solution]

Roberto:

It took a time for me to understand what you meant, but then I realized that you were pointing to save the dynamic template when the values were corrected. And that did the trick! Everything is working flawlessly again.

Thanks a lot for every answer!

[Former Member · Accepted solution]

Hi Jose Luis,

yes this was what I meant; if no one common member value is present then it's necessary to create a default (dummy) value and save the report with this so all the users will open the report without issues.

Regards

     Roberto

[Former Member]

Do you have the "Refresh workbook on workbook open" and "Expand on workbook open" checked on for that particular workbook?

If they aren't, turn them on and save the workbook. That should do it.