Cell-based modelling is a root cause of Excel Hell. Some of the unavoidable issues include:-

1. Simple errors in formula construction, returning error values such as: #VALUE! ; #REF! ; #NAME? ; #N/A; etc.

2. Errors in formulas dependent on other feeder cells that only become apparent later on, usually in different tabs to . . . → Read More: Excel Hell: How Simple Checksums Can Ease The Pain of Financial Modelling