"I would like to know the proper way to control forms that are used for tracking production output. We have a form which is pulling formulas from other tabs. Do we give the final output form a Form # and control that document or do we need to control all three tabs in the Excel spreadsheet?”
We need document control to be sure:
a) we are all using the last version;
b) we are all using the same version, and
c) we are all speaking about the same document.
In your own case, how can you ensure that?
If the Form has a name or a title c) is ensured. If the Form is automatically generated after the Excel spreadsheet, if you control the Excel spreadsheet you will ensure a) and b) for everybody.