Where are Microsoft Office 2011 "My Templates" stored?

[Big Byte]

Hello, I recently bought a 13" MacBook Pro to replace my old iBook G4, which required me to also buy Microsoft Office 2011 because my MBP cannot run Microsoft Office 2004.

So, I have found out how to transfer my templates from MO 2004 on my old iBook G4 to MO 2011 on my new MBP, but my templates are not being stored in MO 2011 as they were in the folders I created in MO 2004. Does anyone know how to create folders and subfolders in MO 2011 to store templates?

And, where is the "Normal.dotm" file stored so I can access it and modify it as well?

One final question, where do I find the "Normal.dot" template for Excel to customize the toolbar so that it stays the same every time I open it up?

Thank-you.

 

[dZp]

By default it should be set to:
~/Library/Application Support/Microsoft/Office/User Templates/

but you can change it via the Preferences menu item:
Word > Preferences... > File Locations > User templates

 

[Big Byte]

Thanks, bud! I did a little web search after I posted my thread and found the same solution that you gave me (and how to "unhide" the library)... but, as stated after I edited my post, new problems have arisen. Any further insight?

 

[James_C]

This article explains how you can change the default workbook template.

 

[dZp]

Not sure...
Can't you simply ctrl+click the toolbar and select Customize Toolbars and Menus... ?

Edit: nvm... I see now, by James reply, what you probably meant.

 

[Big Byte]

This article explains how you can change the default workbook template.

Worked like a charm, thanks!

Now, the only issue is creating folders and subfolders in MO 2011 for my templates, as I did in MO 2004. Does anyone know how to do that?

EDIT:

Darn, two other issues (bringing it up to three) have arisen:

1) I've created and saved templates (i.e. with .dotx extensions), but don't see them in the My Template folder in my library under Application Support. Does anyone know where they are?

2) How can I delete the templates that come installed with MO 2011 or, at least, remove them from the "New from Template" menu when I click the icon in Word?

Thanks.

 

[Cain613]

Not working

Ive tried everything that has been posted in these responses but nothing is working. Anybody have any suggestions?

 

[dowsmith]

Solved! (at least for me). The article mentioned above NEARLY solved the problem - but not quite, as it resulted in Excel trying (and failing) to open my Word templates... I needed to tweak it a bit.

1. Open Excel 2011

2. Tweak the workbook as desired

3. Choose File > Save As, naming it just Workbook

4. Click the Format: drop-down button and choose Excel Template (.xltx)

5. This auto-selects location (Library:Application Support:Microsoft:Office:User Templates:My Templates): you need to create a NEW folder in My Templates, and name it something like ‘my excel default template’

6. Change Excel Preferences: select General and set the ‘At startup, open all files in’ location to the new folder you created above.

7. In Finder, navigate to that folder and REMOVE .xltx extension. Ignore standard warning.

(8. Excel preferences can be set to have workbooks open with just one worksheet. If you have several worksheets in the Workbook Template file, repeat the ‘saving’ steps above, this time renaming the template as ‘Sheet’)

9. Now relaunch Excel 2011 and you’ll be looking at a worksheet that picks up your new template by default.