+ Reply to Thread
Results 1 to 11 of 11

Color palette gone crazy !

  1. #1
    Registered User
    Join Date
    02-23-2004
    Posts
    58

    Color palette gone crazy !

    Dear All,

    My color palette is having a problem for each colored font in red i have is turning to grey after restarting excel , despite the fact that i am changing from tools>options>color>clicking on the grey and modifying to red and the clicking apply , eventhough when i restart excel it turns to grey again !Also the dark blue is turning to grey and vice versa.

    Any one knows why this is happening and how to solve it?

    Thank you much .

  2. #2
    Forum Contributor
    Join Date
    10-30-2007
    Location
    Norway
    MS-Off Ver
    MS Office 2007
    Posts
    345
    It sounds like you somehow have managed to do do some changes to your color pallette and then saved this with your default workbook. You can customize excel with many options to make the workbooks look like you want. If you want these options to apply to all workbooks you create you can save it to a template called book.xlt and save it in the \XLStart folder. the placement of this folder will vary on different operating systems.

    Search for XLStart on your harddrive and let me know what you find in this folder.

  3. #3
    Registered User
    Join Date
    02-23-2004
    Posts
    58
    Hi,
    Thank you for your reply, i searched XLStart but nothing was in it empty 0 byte!

  4. #4
    Forum Contributor
    Join Date
    10-30-2007
    Location
    Norway
    MS-Off Ver
    MS Office 2007
    Posts
    345
    check: Tools -> Options -> General.

    This have an option called: "At startup open all files in:".
    Do you have an entry in this field ?

  5. #5
    Registered User
    Join Date
    02-23-2004
    Posts
    58
    This field is also empty !
    could it be an add in for ex or a html maker which caused that ?

  6. #6
    Forum Contributor
    Join Date
    10-30-2007
    Location
    Norway
    MS-Off Ver
    MS Office 2007
    Posts
    345
    It can be an add-in, but try this:
    Open Excel with a blank workbook.
    Edit your colour pallette, so it is back to normal.
    Save this workbook as a template in the XLStartup folder. Name the file book.xlt (not book1.xlt).
    Restart excel, and check your colour pallette now (before you open any files).

  7. #7
    Registered User
    Join Date
    02-23-2004
    Posts
    58
    It seems that things came to the normal before saving this template ? i will try it whenever Excel will change colors in the palette again in order to see if it works and shall revert.

    Many thanks to you !

  8. #8
    Forum Contributor
    Join Date
    10-30-2007
    Location
    Norway
    MS-Off Ver
    MS Office 2007
    Posts
    345
    It could be one of your workbooks that cointains this pallette changes. If you opens a workbook with pallette changes it will affect all the other workbooks you open or create until you restart Excel.

  9. #9
    Registered User
    Join Date
    02-23-2004
    Posts
    58
    Any way to reset that workbook if i find out which one?

  10. #10
    Forum Contributor
    Join Date
    10-30-2007
    Location
    Norway
    MS-Off Ver
    MS Office 2007
    Posts
    345
    There is an option for copying colour palette from one workbook to another, but for this to work you must have a workbook that has been saved with a custom palette. This means you must have a workbook where you first have changed something in your palette and then changed it back to default colours before you save it.

    The problem with custom palettes is this:
    Files with standard pallette does not contain palette information. They will display default colours as long as you only work with files containing no palette information.
    If you open one file that contains a custom palette this will change the display colours of all other workbook you open until you restart Excel. After restart you can reload your workbooks and they will display in the correct standard colours.

    This information is not something I have seen documentation about, it is only my personal experience with custom colour palettes. Anybody please feel free to correct me if I'm wrong.

    I have made you a empty wookrbook that should contain a pallette with standard colours. This you can copy palette from, if you find the problem woorkbook. Remember to save it after you have corrected it.

    Open my woorkbook
    Open your problem woorkbook
    In Tools -> options -> colour , copy colours from my workbook to your woorkbook.
    Save your woorkbook.

    Hope this will solve your problem, and that you remember to don't use custom colours in your workbook if you don't have to The 40 standard colours should be enough for most cases.
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    02-23-2004
    Posts
    58
    Bilion thanks to your support !

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1