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?