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