Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Kent, England
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Excel Workbook (Office 2003)

    Can anyone help?

    I have created two xlt templates (Book.xlt and Sheet.xlt) which is stored in XLStart, both templates have specific colours within the colour palette. When opening Excel or clicking on the File/New Icon, the workbook that is created has the correct colours. When going to the Task Pane and select Blank Workbook, or Templates/On my computer then Workbook under the General Tab the set of colours are incorrect.

    I have taken a look as some of the posts in connection with the Default Excel Workbook and have noted that in Office 2003 there is a file named Excel11.xlb. Could this be storing the incorrect colours? Can the file be opened as I am having no success opening the file?

    Many thanks
    Jack

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

    Re: Default Excel Workbook (Office 2003)

    You seem to come up with the more or less the same question every 6 months or so. See the thread starting at <post:=490,389>post 490,389</post:> and the one starting at <post:=435,455>post 435,455</post:>. As noted there, the "Blank Workbook" in Templates is not really a physical template, it represents factory settings (more or less).

    Excel11.xlb is not a workbook. It is a file that holds customizations to built-in toolbars, custom lists and the like. Custom color palettes are not stored there, they are stored in individual workbooks.

  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

    Re: Default Excel Workbook (Office 2003)

    In addition to Hans' comments, if you want your default template to be available from "Templates" (and not just File - New) then add a copy of the template to the TEMPLATES folder.

    Steve

  4. #4
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Kent, England
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Excel Workbook (Office 2003)

    Apologies Hans, and thanks for pointing me to the original post.

    Over the last few months we have deployed the templates to a large number of users. Initially we recommended that users select the File New Icon but as the numbers increase they are creating their workbooks differently, ie using the Task Pane. I just keep thinking there must be a way to change the Microsoft default colours on the Blank Workbook.

    Regards
    Jack

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

    Re: Default Excel Workbook (Office 2003)

    As far as I know, you cannot modify the built-in color palette, only that in specific templates (such as Book.xlt) and workbooks. If someone can prove me wrong, I'd be happy to learn about it.

  6. #6
    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

    Re: Default Excel Workbook (Office 2003)

    This doesn't change it on the default workbook (I agree with Hans, that I think it is "builtin" to excel), but it might be useful to you.

    After the creation, of the workbook (if created without the default color scheme) you could just import the "correct color scheme" using tools - options - color (tab) "copy colors from"...

    This would allow if done incorrectly (when people can not follow directions) a way to fix the color scheme.
    Steve

  7. #7
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Kent, England
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Excel Workbook (Office 2003)

    Thanks Steve.

    As a last resort I will copy the colours over but am a little frustrated that Microsoft are forcing their default colours into the Excel environment. I have access to a Microsoft consultant within the firm and have asked him to investigate. I am not holding my breath but if he does come up with a solution I will pass the information on.

    Regards
    Jack

  8. #8
    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

    Re: Default Excel Workbook (Office 2003)

    I wouldn't call it "forcing". The color scheme is saved with a workbook.

    They allow the user to create a default "new workbook" and that can save the color scheme. If the user chooses "File New" they get the newly defined default (which is what you want)

    If the user chooses the "new blank" they are choosing the "xl default" (perhaps they should have called it the "Blank XL default workbook", but that is another discussion... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>)

    The user can also select any number of "created templates" (you can add your default to this location also) to start with multiple schemes. If desired you can remove all the templates (except yours) from the template menu so only yours is selectable.

    To me, it seems that your frustration is coming not from MS "forcing", but your company trying to force the users to conform to something, while MS is allowing the user to choose (and not forcing anything).

    Steve

  9. #9
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Kent, England
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Excel Workbook (Office 2003)

    Thanks Steve.

    If only the company could see it your way - my life would be so much easier. Microsoft are now investigating so hopefully they will be able to find a solution - fingers crossed.

    Have a good weekend
    Jack

Posting Permissions

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