LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
KRK KRK is offline
external usenet poster
 
Posts: 91
Default big, slow spreadsheet

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spreadsheet cals very slow, I have 2 Gig Ram...? bill Excel Discussion (Misc queries) 2 November 6th 07 12:50 AM
Spreadsheet slow on one PC but not another one homer Excel Discussion (Misc queries) 1 February 13th 07 02:23 PM
Spreadsheet performance is slow Kristi Excel Worksheet Functions 7 January 5th 06 03:17 PM
Opening spreadsheet & word very slow others ok Nokose Excel Discussion (Misc queries) 2 July 18th 05 03:24 PM
very slow spreadsheet joe Excel Discussion (Misc queries) 1 June 18th 05 01:51 AM


All times are GMT +1. The time now is 08:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"