Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Problems
My shop has just gotten new PC's (all machines were created from the same
image) Office 2003 is loaded. One of my co-workers is have a very strange problem with her excel. Any workbooks loaded on her PC are displayed on the screen with out any color (text color or background). The same file when loaded on my PC shows the colors properly. The appearance is as if the entire worksheet had been selected and then the background color was set to "no fill". Things that have been checked: 1. Options|Colors|Reset colors; no change 2. Using the quick color assignment toolbar buttons (the proper color selections appear with the button-drop-down, but clicking the button will not assign any color) 3. The workbook and worksheet are UN-protected (changes are allowed- Bold setting still works on the appearance of the data) 4. Page-Setup|sheet|Black and White is NOT checked and even if it is checked the screen colors do not change untill you look at a print-preview. 5. Display Properties|Color is set to Highest(32-bit) 6. Screen Saver is one of the default WindowsXP settings. What could cause this? Before we un-install and re-install Office... does anyone have any ideas of something else to try? -- Regards, John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Problems
When you say "without any color (text color or background)", I assume
you mean everything looks white? Is the text visible or no? Is there a cell grid (the default light gray grid) or no? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Problems
Text is visible. All appears black and white. Grid lines are black (all of
the borders are set to the solid black line). Still the oddest part of all this is that when I try to set a background or text color, the button click does nothing at all. -- Regards, John "keeena" wrote: When you say "without any color (text color or background)", I assume you mean everything looks white? Is the text visible or no? Is there a cell grid (the default light gray grid) or no? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Problems
AFAIK there is no Excel property that would cause this. Doesn't mean
there isn't one...I've just never heard of it. Some other items which could affect formatting and may be worth checking Conditional Formatting Embedded code / Add-ins Sorry I couldn't help you more. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Problems
Thanks for the replies :)
Conditional formatting or embedded code would be saved with the workbook. This would have caused the same issue on my PC but that was not the case. The part that warrants further checking is any Add-in(s) installed (but my thought is that there are not any, because this is a new install from an image for the dapartment) -- Regards, John "keeena" wrote: AFAIK there is no Excel property that would cause this. Doesn't mean there isn't one...I've just never heard of it. Some other items which could affect formatting and may be worth checking Conditional Formatting Embedded code / Add-ins Sorry I couldn't help you more. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Problems
Still the oddest part of all this
is that when I try to set a background or text color, the button click does nothing at all. That sounds like the sheet is protected (formats only perhaps). You said it wasn't in your OP but might be worth double checking. Regards, Peter T "John Keith" wrote in message ... Text is visible. All appears black and white. Grid lines are black (all of the borders are set to the solid black line). Still the oddest part of all this is that when I try to set a background or text color, the button click does nothing at all. -- Regards, John "keeena" wrote: When you say "without any color (text color or background)", I assume you mean everything looks white? Is the text visible or no? Is there a cell grid (the default light gray grid) or no? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Problems
Both worksheet and workbook protection were off (when looking at the menu,
both of the choices were to "Protect"). Is there a seperate protection for formatting-only somehere? I'll double check on Monday, but I think they have already uninstalled and re-installed Office. -- Regards, John "Peter T" wrote: Still the oddest part of all this is that when I try to set a background or text color, the button click does nothing at all. That sounds like the sheet is protected (formats only perhaps). You said it wasn't in your OP but might be worth double checking. Regards, Peter T "John Keith" wrote in message ... Text is visible. All appears black and white. Grid lines are black (all of the borders are set to the solid black line). Still the oddest part of all this is that when I try to set a background or text color, the button click does nothing at all. -- Regards, John "keeena" wrote: When you say "without any color (text color or background)", I assume you mean everything looks white? Is the text visible or no? Is there a cell grid (the default light gray grid) or no? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Problems
In XL2002+ there is a drop down list of options, including formats, you can
include/exclude with protection. Regards, Peter T "John Keith" wrote in message ... Both worksheet and workbook protection were off (when looking at the menu, both of the choices were to "Protect"). Is there a seperate protection for formatting-only somehere? I'll double check on Monday, but I think they have already uninstalled and re-installed Office. -- Regards, John "Peter T" wrote: Still the oddest part of all this is that when I try to set a background or text color, the button click does nothing at all. That sounds like the sheet is protected (formats only perhaps). You said it wasn't in your OP but might be worth double checking. Regards, Peter T "John Keith" wrote in message ... Text is visible. All appears black and white. Grid lines are black (all of the borders are set to the solid black line). Still the oddest part of all this is that when I try to set a background or text color, the button click does nothing at all. -- Regards, John "keeena" wrote: When you say "without any color (text color or background)", I assume you mean everything looks white? Is the text visible or no? Is there a cell grid (the default light gray grid) or no? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
aauugghhh...#div/o problems & various average formula problems | Excel Worksheet Functions | |||
Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
Colour (color) problems | Excel Worksheet Functions | |||
Color viewing problems-Cell | Excel Worksheet Functions | |||
Problems merging an excel file due to code or file problems? | Excel Programming |