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.