Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 803
  • Last Modified:

Is it possible to modify the Blank Workbook in Excel 2010.

If I place Book.xltx in the xlstart folder this launches the correct default, if I add new to the quick launch bar it launches the correct default, if I launch a new workbook from Ctrl N it launches the correct default, but if I click on start new and then select blank workbook it launches the default Microsoft Workbook. I am aware that some settings can be configured in Options, General, ‘When Creating New Workbooks’ but there are insufficient settings available for our requirements.
0
sclltd
Asked:
sclltd
2 Solutions
 
Jignesh TharSenior ManagerCommented:
Sclltd - I dont believe there is a way to tell excel to use book.xslt when Office button -> New is used. It overrides template.

See below as well (not for 2010 though)
http://www.eggheadcafe.com/software/aspnet/35494836/blak-workbook-and-bookxltx.aspx
0
 
sclltdAuthor Commented:
I thought this might be the case but was hoping. Do you know if this operation can be turned off with a GPO?
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

You can't override that. This is the factory default, so to say. Same as in Word, where you can have all kinds of customisations in the Normal.dot (or Normal.dotm, respectively). If you delete that, and Word creates a new Normal.dot(m) it will have the defaults as defined by Microsoft.

cheers, teylyn
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now