Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel color change (Excel 2003 SP2)

    Trouble ticket came in for Excel 2003 SP2 running on XP Pro SP1 where client reported when opening an existing file, or import, changes to Yellow, or Green or Brown. I have suggested the client start Excel with the /automation and the /safe commandline flags but am curious if anyone has seen this color change phenomena? Or is it phenomenon?

    -Jester
    I know enough to know I don't know enough

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel color change (Excel 2003 SP2)

    What changes color? The Excel window, or some cells, or all cells, or ...?

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel color change (Excel 2003 SP2)

    What changes color? A particular cell? All cells? The user?
    Legare Coleman

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel color change (Excel 2003 SP2)

    The user probably turned red...

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel color change (Excel 2003 SP2)

    Attached is a screen shot showing the normal display as created. I will post a second image showing the same file as displayed in the user's Excel.

    -Jester
    I know enough to know I don't know enough

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel color change (Excel 2003 SP2)

    Here is same file showing what has changed as soon as the file is opened.

    -Jester
    I know enough to know I don't know enough

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel color change (Excel 2003 SP2)

    Have you checked for
    - Conditional formatting
    - Event code in the worksheet module for the PV sheet
    - Event code in the ThisWorkbook module
    - A macro called Auto_Open

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel color change (Excel 2003 SP2)

    Also, does this happen only in that specific workbook, or in some workbooks, or in all workbooks?

  9. #9
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel color change (Excel 2003 SP2)

    Two possibilities come to mind:

    1- Excel's color pallet contains 56 colors. It is possible for the user to change which 56 colors are in the pallet. Is it possible that one of the two machines has changed what colors are in the pallet?

    2- I think that Excel uses the colors specified by the Display Properties Control Panel Applet to color its displays. Are the two PCs using different color schemes?
    Legare Coleman

  10. #10
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel color change (Excel 2003 SP2)

    Learned this morning that the user only has this issue with one file but the techs on site are going to reimage his machine for other reasons so I may never know the real cause.

    Thanks,
    -Jester
    I know enough to know I don't know enough

  11. #11
    Star Lounger
    Join Date
    Jan 2004
    Location
    Westervoort, Netherlands
    Posts
    56
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Excel color change (Excel 2003 SP2)

    The possibilty 1 could be happening. I have had this problem some time ago as well with a computer in holland and the UK.

    Regards Marcel

Posting Permissions

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