In large workbooks that I use, everytime I enter a value or text that is used
by a formula, it takes a while to finish processing so I set the calculation
(Tools\Options\Calculation).

If that workbook was opened first, the next workbook/s that I will open will
be automatically set to manual calculation (though it is originally set to
automatic calculation).

Try opening the workbook with the default color palette followed by the
workbook with the custom color palette and see what happens.

Exceleration wrote:
This happens when any workbook with a custom palette is open. What do you
mean on manual automatic calculations?

Does this always happen or only when the workbook with the custom color
palette is opened first? I experienced the same inheritance but on
[quoted text clipped - 21 lines]

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200909/1