View Single Post
  #1   Report Post  
JB2005
 
Posts: n/a
Default Excel Option Conflicts

I need a workbook to run with specific options which may conflict with
options already established by open workbooks sharing the same EXCEL.exe
process.

e.g one workbook needs "Manual Calculation", others "Automatic Calculation"

I believe one solution is to ensure that whenever this workbook is opened,
it runs (exclusively) a new EXCEL.exe process.

How can I ensure this works for all users accessing this file?

Or is there a smarter way?