View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
robert morris robert morris is offline
external usenet poster
 
Posts: 222
Default Excel 2007 hangs on any change to large range of data

Keep using it. You will love it, all except it is slower, mostly in opening
Workbooks.

Bob. M.

"shoemaven" wrote:

Just started a new job - using 2007 for the first time -
Working with a 1.17MB file - subtotals take 2-3 minutes to complete, as does
deleting 5000 rows of data (filtering subtotal lines and deleting balance) -
I'm sure 2007 isn't supposed to be slower than 2003! Are there any settings I
might need to change to speed things up?