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

=IF(BExGetData($X$3,$X$6,$B13,$X$4,$X$5,$G13,W$11,W$12)="#NV",,BExGetData($X$3,$X$6,$B13,$X$4,$X$5,$G13,W$11,W$12))

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?

Regards,

A

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