Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Report Refresh

Dear Experts,

We are facing the issue with the formulae in the excel report.

Below are the details.

1. We have two reports sharing the row axis. Report 1 and Reprot 2. Both of them are input enabled and are dynamic.

2. Report 1 has formula refrencing the cells of Report 2. (Formula is applied in the coulumn through the formatting sheet)

3. Upon refresh of the work book, Report 1 is getting refreshed first and then Report 2.

4. I believe because report2 is getting refreshed after report 1, cells with formula in the report 1 are ending an error message as # Ref.

So is there any way to make Report 2 refresh first and Report 1 later.

For getting the reports working momentarily, as a work around I am doing the refresh two times. Which is turning the '# Ref' error to appropriate formula on second refresh.

Though in the above example I have given only 2 reports, we have around 8 other reports in the same workbook performing different functionalities. So making the workbook refresh two times is causing a lot of performance issues.

Please suggest how to go about this refresh issue.

Thanks,

Shiva

Former Member
Not what you were looking for? View more on this topic or Ask a question