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?

I don't think that there is a way to ensure this.

You could give them instructions, you could give them a workbook that creates
another instance of excel, sets the calculation mode, and then opens the
file(s).

But that wouldn't stop anyone from just File|open your workbook (with the wrong
setting).

By the way, personally, I try not to use multiple instances of excel. I think
it makes it much more difficult to share information (copy|paste) between them.

JB2005 wrote:

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?

--

Dave Peterson