Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.
Workbook calculations
Name: Steve UK Date: March 28, 2006 at 07:41:59 Pacific OS: Win2k CPU/Ram: 1400/512 Product: Dell
Comment:
Hi
Excel workbook A is set to manual calculation. Workbook B is set to Automatic calculation.
When I open workbook A and workbook B is already open then the automatic calculation seems to be applied to workbook A (so it opens and calculates straightaway without any prompt). Workbook A has lots of links (takes 5 mins to calculate) but no links to workbook B.
Is this normal? Its really annoying when I have a customer waiting.
Name: Tacticus (by tacticus) Date: March 30, 2006 at 00:52:47 Pacific
Reply:
Unfortunately it is normal. The automatic calculation option is set in the instance of the application not in the workbook.
When you open your workbook by double-clicking the file it will open in the same instance of excel that is currently running and therefore inherit the settings of the instance.
There is a work-around: If you open excel and then open the file from there each time, you will have a different instance of excel for each worksheet.
Summary: I have an Excel file that is doing something odd. First of all, Excel 97 SP2. Now when I open this file it has tons of formulas and it can both auto-update or manually update just fine. The problem...
Summary: Hello my friends. Got another question to throw into the fray. Is there a way to convert a workbook to be embedded to a website? I need the workbook to be usable (its a calculator). The workbook also ...
Summary: I believe Excel sets it's calculation mode based on the first workbook that is opened during a given session. Is it possible that these "random" occurrences are happening because some other already-op...
0 
Rules problem in OE 6
