When trying to print reports, I get an error message “Cannot shift objects off sheet” or Exl-Plan fails to hide columns in certain reports?
This is an Excel problem which can arise after you have inserted Comments within the body of a monthly or quarterly report. It will manifest itself when Exl-Plan’s macros fail to correctly hide certain columns to produce a compacted report, for example, to hide all monthly columns when printing a full-year output report or, in the case of Ultra and Ultra Plus, to hide certain monthly columns when printing monthly or full-year assumption and output reports. To confirm the source of the problem, go to the relevant sheet and hide a series of columns in order to provoke the message “Cannot shift objects off sheet”. From our experimentation, the problem seems to almost occur at random.