Manual Calc taking way too long

Greetings all,

I'm having a problem with my manual calc taking 20-30 seconds to finish.
Here's the scenario...

I'm basically creating a series of Trial Balances (accounting schedule) for our various company departments all in one workbook. The workbook includes two source data files..one for financial actuals and one for financial budget, and a trial balance worksheet for each department...when finished it should be about 30 TB's for 30 departments. I'm basically using Sumif statements to bring in the data that matches an account/dept/month criteria for each of these worksheets. The file itself is not that big (7,727 kb) so that shouldn't be a problem. Also, I've gone ahead and copy/valued a number of the sumif's thinking that might help but didnt really do much good.

Anyway, first time posting here so looking forward to any helpful suggestions.

Thanks!

Unfortunately, calculation can take a bit of time for larger files (from my experience a 7,000 kb is on the larger side). Your best hope, usually, is to try to figure out if there is a more efficient way of displaying/calculation the data. Normally, I would suggest posting a .zip sample of the data, but in the case of a company's financials, that is usually a bad idea.

Your best bet would be to post at least a small sample of the spreadsheet with fabricated data. Hopefully, then we can at least see what you are doing and if it is the best way to go about it.

More specifically, array formulas or lookup/vlookup/match/countif/sumif formulas that cover a large range often slow down a spreadsheet because Excel looks at each value in the range and tests it. Also, if you have any macros in the spreadsheet, those should be looked at as well for efficiency.