Shotgun Surgery

This smell occurs due to a formula F that is referred to by many different formulas in different worksheets. The chances are high that many of the formulas that refer to F will have to be changed if F is changed. Shotgun Surgery could have an impact on the maintainability of a spreadsheet, since it requires the user to make a number of changes when F is changed.

Related smells: Shotgun Surgery

Reference

F. Hermans, M. Pinzger, A. van Deursen, “Detecting and Visualizing Inter-Worksheet Smells in Spreadsheets”. ICSE 2012, pp. 441–451.