View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Stop an in-process subtotals calculation

Go and grab a coffee and then talk with someone about what you did last
weekend. When you get back you will have stopped the subtotal.
--
HTH...

Jim Thomlinson


"Mehrlich" wrote:

I started a subtotals calculation in a spreadsheet of about 8000 lines. The
calculation is taking a very long time. Can I successfully stop the
calculation, as I have figured a pivot table that can faster achieve my
query? How do I stop it?