Manual calc for one sheet, auto calc for another

  • Thread starter Thread starter Hall
  • Start date Start date
H

Hall

Is it possible to set one sheet to manual calculation and another sheet to
auto calculation, in the same workbook?

Thanks
 
Hall,

No. It's not even possible to set it differently for two workbooks. Stranger than fiction.
You could do it with a Sheet_Activate sub in the ThisWorkbook module.

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting. But if you bottom-post
to a reply that's already top-posted, the thread gets messy.
When in Rome...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opening multiple excel sessions 2
Automatic Re-calc 9
Formulas Won't Auto Calc 1
New to Excel Macros 1
select a range on another sheet 1
Recalculating when an Excel sheet gets the focus from outside Excel 10
Calculation Settings 3
check if excel sheet in manual calc mode 1

Back
Top