300 row, 25 columns is not at all large.
Frequent causes of slow calculation:
VLOOKUPs with the 4th argument set to FALSE
Array formulas
User Defined Functions
For lots of information about calculation speed, visit Charles Williams' site:
www.decisionmodels.com
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"KRK" wrote in message ...
| Hello,
|
| My spreadsheet is getting very large, 300+ rows and 25+ columns, most cells
| contain formulae. There is also a complex bar chart on the sheet.
|
| Whenever I add new data it seems to take a long time ( a few seconds) to
| update the spreadsheet. This is not a major problem but can be annoying when
| I have a lot of new data to add.
|
| I have wondered about turning off the 'automatic' re-calculation option and
| calculating manually.
|
| Does anyone have other ideas or suggestions please ?
|
| Thanks
|
| KK
|