I work for an organization with a yearly budget that is an Excel spreadsheet consisting of about 25 large sheets that are linked to one another. There is a big summary sheet that draws it's numbers from sheets that have more detailed accounts (and projections) of revenue and expenses, which in turn take numbers from even more detailed sheets.
It has gotten to the point where editing the spreadsheet is slow, corruption is not uncommon. and it is unclear whether data is always correctly linked. Last year I found one revenue stream to be unaccounted for.
Is there an alternative software for detailed budgeting that handles large files better? Someone suggested Access and while I could see it being used that way, it's not really written to be used for budgets in the way that Excel is. Is there any other budget software out there?
Or is this size of a file ok for Excel and it's the computer that needs more memory/virtual memory/faster CPU etc? (I don't know what our business manager's computer is like, but it's decent though not a cutting edge machine.)