Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Oct 2009
    Location
    Virginia, USA
    Posts
    34
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Our company has migrated to Office 2007 and I have been unable to make the default font Arial instead of Calibri for charts in Excel and PowerPoint and have the change stick after I exit the program and come back in.

    HELP! This is driving me crazy.

    Thanks in advance for your help,
    Georgette

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Have you tried saving the chart as a template and setting that as the default chart?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Lounger
    Join Date
    Oct 2009
    Location
    Virginia, USA
    Posts
    34
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Making a chart template would only change one chart. I can choose Page Layout, Font, and Office Classic 2 (which applies Arial as both the body and heading font) and this changes the defult font to Arial but I cannot make that "stick" when I close Excel.

    I even tried saving this as a template file, Book.xltx, located here C:\Users\georgette\AppData\Roaming\Microsoft\Templ ates but when I reopen

    • Excel does not remember that I made the change or
    • it is basing the new file opening on a template with a different name or different location.


    Does anyone know WHERE Excel 2007 keeps its "global" template(s) or WHAT it/they are called (for Word it is Normal.dotx or Normal.dotm)?

    Thanks in advance for your help,
    Georgette

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Your template name is correct but needs to be in one of the XLSTART folders. Note also that it will not be used if you create a worbook via the Office Button - New - blank workbook option, but does work for Ctrl+n
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Lounger
    Join Date
    Oct 2009
    Location
    Virginia, USA
    Posts
    34
    Thanks
    3
    Thanked 0 Times in 0 Posts
    What do you mean by CTRL-N?
    If I just open Excel by clicking on the program icon wiil the spreadsheet be backed by templates in the XSTART folder?
    Thanks in advance,
    Georgette

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Ctrl+n is the Excel shortcut key for creating a new workbook. If you have your template in XLSTART, then it will be used when opening Excel, yes.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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