I have always separated input worksheets and formula (report) worksheets as
a general guideline as it has given my apps the ability to operate in manual
calculation mode. Calculations, row/hiding and those types of operations
occurred when a user either attempted to view a report or perform a printing
operation. I have inherited a moderately complex workbook with inputs and
calculations combined which I do not care for as the user expects to see the
calculations as data entry is being performed. Example : There are inputs
for expenses a,b,c,d and a total column for the expenses. All information
on this input sheet (Inputs and calculated columns) flows to a report sheet,
making the formulas redundant. This design is present throughout the
workbook. Am I off base here with my complaint?