Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    For Win XP, O'2003 Uk

    If I manually modify my color palette in Excel (Tools, Options, Color) - where will these changes then be stored?
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    In the active workbook. Each workbook has its own color palette (which starts out as the default palette).

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I believe they are stored with the workbook, each able to have its own pallete of colors. Thus if a sheet from one workbook is copied into another the color of the items will change to reflect the pallete in that workbook

    Steve

  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Just needed a "mind refresh".

    Thanks.
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  5. #5
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am encountering trouble with color palettes on many workbooks. I was advised to use the Reset button on the color options. It does nothing. The defect causes a dark blue/gray background on many rows and cells, making black text almost invisible. I've tried this many times and the Reset approach never works. Thanks for any advice.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Could you attach a small workbook that exhibits this problem? You can remove most or all contents.

  7. #7
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Look at the color pallet on this one..same as in my book.xls in startup. The pallet in Options does not seem correct and yet it will not "reset". When I open up workbooks from others, I get this type of pallet. I know they do not send them wiht this fill color. Thanks.
    Attached Files Attached Files

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Which version of Excel are you using?
    When I open your sample workbook in Excel 2002 (XP), it has the default color palette:

    [attachment=84588:x.png]
    Attached Images Attached Images
    • File Type: png x.png (1.2 KB, 4 views)

  9. #9
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='783358' date='07-Jul-2009 11:02']Which version of Excel are you using?
    When I open your sample workbook in Excel 2002 (XP), it has the default color palette:

    [attachment=84588:x.png][/quote]
    That's incredible. That's not what I'm seeing a this end. That looks like what it should be, but I do not get that palette. We are currently using 2003 in XP, but are getting 2007 files from other people. Here is an image of what I see everywhere. Any suggestions? Could it be a hardware issue?
    Attached Images Attached Images

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Does this just happen with workbooks that were originally created in Excel 2007 or also with workbooks that you create in Excel 2003.

  11. #11
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Most of our files are still created in 2003.

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Either there is something wrong with your video card, or else with your installation of Excel.

    What happens if you select a color then click Modify...? Do you get normal-looking colors as in this screenshot, or distorted/flat colors?

    [attachment=84593:x.png]
    Attached Images Attached Images
    • File Type: png x.png (7.1 KB, 0 views)

  13. #13
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I see the same color fields in both tabs as you show. Amazing. Yet the pallets in the workbooks are missing colors. Is there any macro to reset? Why do you think that reset button doesn't work? because there's nothing wrong with the pallet in the options tab? guess so. If I were to "customize" the "bad pallets" in specific workbooks back to defaults, woud that eliminate the color problem? Can I be shown which of those colors I should select in the rebuild? Thanks.

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can try importing the color palette from a workbook that has a normal palette. Both workbooks must be open for this.

  15. #15
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='783783' date='09-Jul-2009 10:51']You can try importing the color palette from a workbook that has a normal palette. Both workbooks must be open for this.[/quote]
    Can you give me the steps? I don't see anything in the menus about such a process. BTW I just had someone send me from their laptop a workbook with a good color pallett. When I opened it up on my laptop....bad palette! Is there any way to test my on-board video for this?

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •