This article will explore the obstacles of static spreadsheets, provide advice on how to overcome these obstacles, as well as ways to convert spreadsheets to web applications.
https://www.techradar.com/pro/overcoming-spreadsheet-limitations-in-business-planning