Excel as a production tool — when do its limits show?

Excel is still a good tool in industry. It is fast, familiar and flexible. It can be used to model a new way of working before anyone knows whether that way should become permanent. The problem is not Excel. The problem appears when Excel becomes the system.

The limit usually arrives quietly. First the sheet belongs to one person. Then a copy is made. Then colours, filters and formulas start carrying responsibility that nobody named. When someone is on leave, the information is stuck. When billing asks for actuals, the answer depends on whose file is opened.

When Excel is still enough

Excel is enough when the information is bounded, there are few users, and the sheet is clearly temporary. It is also enough when a new model is being tested: which fields are needed, who records, what is reported.

A good sign is that the sheet can be closed if its owner is away for a week. A bad sign is that everyday work stops.

Excel is an excellent start. It is rarely a durable way to keep the truth of production in one place.

When the limits show

The limits show when the same information is needed in several jobs at the same time. Supervisors record in the field, finance needs actuals, maintenance wants history, and management asks for the current state. Excel does not prevent this, but it also does not keep versions, responsibilities and timestamps together.

• several versions of the same truth
• recording after the fact, not with the work
• formulas nobody dares to change
• billing or payroll waiting for a manual transfer

When the limit is reached, the answer is not “a better spreadsheet”. The answer is to see which information is shared, and who needs to see it without a file being sent onwards. Then a ready-made product or a light custom view can take the core, and Excel can return to the job where it is strongest: quick modelling.