Skip to Content

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

Formulas in Workbook causing the Workbook to open very slowly

Hi Everyone,

I have a very long pending issue fro our users. We have a workbook which has two queries inserted. And there is a Formula which is hardocded up to 5000 rows. And due to thiis workbook is opening very slolwly.

The Formulas is


The above formula replaces #NV value with a blank and then if there is any other value apart from #NV, then it calculates a different value in the back end. Since the business , does not know howmany rows of data comes, so he hardcoded the formula for 5000 rows as this is the maximum count.

Can anyone please provide a solution to avoid so many hardcoded formulas and have an alternative using some macross.

Please feel free to ask questions?



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