Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 - Color Palette problem.
Hello all and thanks in advance for your input,
I am having a trouble with a user on my network experiencing a color palette problem: If two workbooks are opened in the same instance of Excel, one with a custom color palette and the other with default, the workbook with the default color palette inherits the custom color palette. I can duplicate it as many times as I want on the "afflicted" computer, but can't duplicate it on my machine - even with the same files. Both machines have the same version of Excel (2002 SP3). I've read a handful of other posts of users with the same problem but haven't found any solution. FYI, these workbooks contain no VBA (no modules and blank form modules). I was logged in as the owner of the machine when I tested this on his machine. I hope there's a solution out there! Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 - Color Palette problem.
Does this always happen or only when the workbook with the custom color
palette is opened first? I experienced the same inheritance but on manual/automatic calculation. Exceleration wrote: Hello all and thanks in advance for your input, I am having a trouble with a user on my network experiencing a color palette problem: If two workbooks are opened in the same instance of Excel, one with a custom color palette and the other with default, the workbook with the default color palette inherits the custom color palette. I can duplicate it as many times as I want on the "afflicted" computer, but can't duplicate it on my machine - even with the same files. Both machines have the same version of Excel (2002 SP3). I've read a handful of other posts of users with the same problem but haven't found any solution. FYI, these workbooks contain no VBA (no modules and blank form modules). I was logged in as the owner of the machine when I tested this on his machine. I hope there's a solution out there! Thanks -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 - Color Palette problem.
This happens when any workbook with a custom palette is open. What do you
mean on manual automatic calculations? "pogiman via OfficeKB.com" wrote: Does this always happen or only when the workbook with the custom color palette is opened first? I experienced the same inheritance but on manual/automatic calculation. Exceleration wrote: Hello all and thanks in advance for your input, I am having a trouble with a user on my network experiencing a color palette problem: If two workbooks are opened in the same instance of Excel, one with a custom color palette and the other with default, the workbook with the default color palette inherits the custom color palette. I can duplicate it as many times as I want on the "afflicted" computer, but can't duplicate it on my machine - even with the same files. Both machines have the same version of Excel (2002 SP3). I've read a handful of other posts of users with the same problem but haven't found any solution. FYI, these workbooks contain no VBA (no modules and blank form modules). I was logged in as the owner of the machine when I tested this on his machine. I hope there's a solution out there! Thanks -- Message posted via http://www.officekb.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 - Color Palette problem.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Color Palette | Excel Discussion (Misc queries) | |||
Excel 2007 Color Palette | Excel Discussion (Misc queries) | |||
Color palette for Excel | Excel Discussion (Misc queries) | |||
Changing the Excel color palette | New Users to Excel | |||
Changing color palette for Excel 2002 | Excel Discussion (Misc queries) |