I've recently found a department for the company I'm working for needs help as they have literally reached the limits of Excel.

They have a sheet with around 30 rows and 150 columns, and they have 100 of these sheets (in a single Excel file). Some parts use formulas, but usually when somebody needs to change something they need to go through every single sheet. The issue is now when they try to add new data Excel won't let them.

I don't even want to know how they share the file or do backups.