When trying to print reports, I get an error message “Cannot shift objects off sheet” or Cashflow 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 output report. It will manifest itself when Cashflow 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. 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.