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: 4189
  • Last Modified:

How do you open an Office 2007 .crtx file in Office 2010?

I have associated the file to Excel 2010 and it still will not open.
0
Mark Simmer
Asked:
Mark Simmer
  • 4
  • 3
1 Solution
 
valmaticCommented:
So to be clear. You are applying the template to an existing chart by
selecting the chart and then on the Chart tools > Design > Type > Chart
Chart Type > Templates.
Selecting the required template (.crtx) and then it says "Can not open
file"?

You are not using Manage Templates and then double clicking the file are
you?
0
 
Mark SimmerTechnology AdministratorAuthor Commented:
No just trying to open it.
0
 
valmaticCommented:
it is not going to just open in excel 2010, you need to be in excel and use one of the ways above.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Mark SimmerTechnology AdministratorAuthor Commented:
Under Manage templates if I try to open it I get an error that the file format is invalid.
0
 
valmaticCommented:
i would try applying it to the chart directly in my first option i wrote earlier. I meant to say don't use manage templates.
0
 
Mark SimmerTechnology AdministratorAuthor Commented:
These instructions only work if the templates are stored in the AppData folder on each computer.  When you select Change Chart Type, the dialog box comes up and lists several types of charts and also provides access to the Templates folder.  However, if you click on the Manage Templates button, this is the path you get: C:\Users\sprice\AppData\Roaming\Microsoft\Templates\Charts.  It won't work unless the chart templates are saved in the appropriate folder on each computer's C drive.  So currently, the only place the templates are accessible is on my computer.  I need them to be accessible on every computer.
0
 
valmaticCommented:
looks like you should have stated this info to start rather than a one line question. So im done with this thread best of luck.
0
 
Harry LeeCommented:
mjsimmer,

Are you system administrator? You need System Administrator Right to do this.

1. Download MS Office Group Policy Templates

First of all, the system administrator has to install Microsoft Office Group Policy template using the Group Policy Editor to the Domain Controller.
You can download the group policy templates at the following location.
For Office 2013,
http://www.microsoft.com/en-ca/download/details.aspx?id=35554
For Office 2010,
http://www.microsoft.com/en-ca/download/details.aspx?id=18968
For Office 2007,
http://www.microsoft.com/en-us/download/details.aspx?id=3795
For Office 2003,
http://www.microsoft.com/en-ca/download/details.aspx?id=9035

2. Installing Group Policy to Domain

Go to the Domain Controller and install the MS Office Group Policy Template

3. Configure Workgroup Templates Location

Open up Group Policy Editor on the Domain Controller, and locate the newly install MS Office Group Policies.
Find the field for Workgroup Templates Location, and set it to a commonly accessable location on the server, which will be used to store company wide templates.

4. Update Group Policy on all machines

Final step is to update the group policy on each machine in the office.
You can either get everyone to log out and log back in, or you can go to each machine and open up a admin right shell windows and run GPUpdate to update the group policy right away.After that, place the template in the server location specified in step 3. Now, all machine should be able to access those templates.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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