#### excelquest23

##### Board Regular

- Joined
- Apr 8, 2006

- Messages
- 58

I'm working with a fairly large spreadsheet involving many calculations and was wondering if someone could give me some tips on designing worksheets to minimimize calculation times.

I'm using Excel 2007. I believe that in previous versions of Excel, calculation times were slower if calculations used data on cells from different worksheets. I also think that calculation times were lengthened by using 'IF' formulae rather than 'OFFSET'.

Could someone tell me if the old rules for improving calculation speeds in previous versions of Excel still apply to Excel 2007?

Also, I'd like help with the following specific cases:

-I need to run calculations using two grids of data. Each grid contains approximately 40,000 rows and 2,000 columns of data. Would the calculations using data from both of these grids be faster if they were on the same worksheet than if they were on separate worksheets?

-In general, is it faster to have calculations split up over multiple worksheets than entirely on one worksheet?

If anyone has a link they can send me that addresses these general questions it would be much appreciated!

Thanks in advance!

Derek