ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Stop an in-process subtotals calculation (https://www.excelbanter.com/excel-worksheet-functions/114852-stop-process-subtotals-calculation.html)

Mehrlich

Stop an in-process subtotals calculation
 
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?

Teethless mama

Stop an in-process subtotals calculation
 
ToolsOptionsCalculation tabSelect Manual


"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?


Jim Thomlinson

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?



All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com