| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 freezing when changing a cell or adding new data
When I add data to a cell or change the format of a cell, every two or three
entries Excel will freeze for about 30-40 seconds. hen you are entering a large amount of data, this can increase the data entry time by tens of minutes. Any one experienced this problem or have a suggested fix? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 freezing when changing a cell or adding new data
Possibly the book's v.calculation-intensive
Try setting the calc mode to "Manual" Click Tools Options Calculation tab check "Manual" OK Then press F9 to recalc only when necessary -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "hoffmaks" wrote: When I add data to a cell or change the format of a cell, every two or three entries Excel will freeze for about 30-40 seconds. hen you are entering a large amount of data, this can increase the data entry time by tens of minutes. Any one experienced this problem or have a suggested fix? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing and Adding data through ODBC connection | Excel Discussion (Misc queries) | |||
| Adding new data to tables and charts in excel sheets from 97/2003 | Excel Worksheet Functions | |||
| Trouble Freezing Panes in Excel 2003 | Excel Worksheet Functions | |||
| Need Help with Freezing/Splitting 2 Frames in Excel 2003 | Excel Discussion (Misc queries) | |||
| excel 2003 accessing hard drive and freezing | Excel Discussion (Misc queries) | |||
Linear Mode
