View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tenacity9 Tenacity9 is offline
external usenet poster
 
Posts: 8
Default F9 Manual Recalculate only for one workbook

Setting Tools-Options-Calculation to manual (ie, have to use F9) changes the
preference for all open workbooks in Excel 2003.

If you only want manual recalculation to apply to a particular workbook
permanently (in other words until the preference is changed back to
automatic), but other open workbooks and all new workbooks to be calculated
automatically (ie, no F9), is there a way to accomplish this easily?

Thanks.