Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel startup option | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel option buttons | Excel Discussion (Misc queries) | |||
Excel - option to extend function in cell to column | Excel Worksheet Functions | |||
Excel Key Field option? | Excel Worksheet Functions |