When using the Profitability Planner in Exl-Plan Super, I see ####### instead of results?
Not applicable to release 2.1 or higher of Super, Super Plus, Ultra or Ultra Plus – to check release, select *Exl-Plan Help | About Exl-Plan …. This arises when all the sales groups are not being used for first-year projections. The simplest solution is to remove the “n/a” value which appears in one or more of the yellow-colored cells relating to prices and then recalculate (press F9). A better solution is to unprotect the Profit Planner worksheet and change all the formulae in the white-colored, price-related cells by replacing “n/a” by the number 0 (i.e. zero without any quote marks).
