View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default big, slow spreadsheet

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
|