It’s easy to outgrow Excel’s capabilities for a specific application. The only option is often to replace Excel with a system designed properly for the specific job.
There are other occasions where by using an add-in, such as gauges, you can achieve something valuable which you can’t do with Excel alone.
But often it makes sense for familiarity to use Excel linked to a database, for [...read more...]