My Templates path in Excel 2010 needs changing.

Hi, in Office 2010 Excel I'm trying to point the 'My Templates' folder to a location on a local server. How do I do this? Thanks in advance.
 

Question Info


Last updated November 7, 2018 Views 18,621 Applies to:
- Close Excel
- Open Word
- Go to the file menu
- Click Options
- Click Advanced
- Scroll down to the section General
  (or is it named Common? I'm not sure, I have a german word only.)
- Click the button File Locations
- Click the Template entry
- Click the Change button
- Search and click on the folder you like
- Click Ok, Ok, Ok until every window is closed

If you open Excel and click 'My Templates" button you should see the templates in your folder.

Andreas.

10 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Brilliant!

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Intuitive... not!

2 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

- Close Excel
- Open Word
- Go to the file menu
- Click Options
- Click Advanced
- Scroll down to the section General
  (or is it named Common? I'm not sure, I have a german word only.)
- Click the button File Locations
- Click the Template entry
- Click the Change button
- Search and click on the folder you like
- Click Ok, Ok, Ok until every window is closed

If you open Excel and click 'My Templates" button you should see the templates in your folder.

Andreas.

Many thanks for the solution. I failed with Excel Expert 2010 exam 77-888 and I want to retake the exam. I come across this issue while I am practicing.  Now I am very clear.  Once again thanks.

Umapathy (MOS - Excel 2007/2010 and Word 2010, MOE - Excel 2010), MCP, MCDST (Legacy)

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Thank you for the instructions.  That was bugging me for months!

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi, in Office 2010 Excel I'm trying to point the 'My Templates' folder to a location on a local server. How do I do this? Thanks in advance.

This is an imbecile implementation from Microsoft. 

It has been like this always, and there is no tools available to solve the problem if you do not have Word installed on your PC.

I, Me, Myself have Office 2010 as a working platform, but I also have Excel 2013 installed for test purposes, but I do not have Word 2013 installed, so I cannot change this setting by any available tools in Microsoft Office.

The solution is:

Open Registry Editor (Start -> RegEdit)

Open HKEY_CURRENT_USER

Locate your Office version (14.0, 15.0 or whatever it might be)

Open Common

Open General

You will find the keys SharedTemplates and UserTemplates in the right panel.

Doubleclick to Edit and satisfy your needs.

Close RegEdit and restart Excel.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

- Close Excel
- Open Word
- Go to the file menu
- Click Options
- Click Advanced
- Scroll down to the section General
  (or is it named Common? I'm not sure, I have a german word only.)
- Click the button File Locations
- Click the Template entry
- Click the Change button
- Search and click on the folder you like
- Click Ok, Ok, Ok until every window is closed

If you open Excel and click 'My Templates" button you should see the templates in your folder.

Andreas.

Many thanks for the solution. I failed with Excel Expert 2010 exam 77-888 and I want to retake the exam. I come across this issue while I am practicing.  Now I am very clear.  Once again thanks.

Hi,

that's not correct.

I am running W10 and went back to office 2010 (2016 is ****). This way to save an excel template does not allow the user to change any details on said excel template and as such at each time a new excel sheet is required it reverts backs to cell alignment that is not what most users (I suggest) like.  The cells alignment for example are all bottom/right and not centred!!!

How do we change all setting so each excel opens in set template format please??

Barry

Barry
The greatest mistake in life is to continually fear that you will make one. – Elbert Hubbard

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.