Solved

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

Posted on 2013-11-19
8
3,255 Views
Last Modified: 2013-11-22
I have associated the file to Excel 2010 and it still will not open.
0
Comment
Question by:mjsimmer
  • 4
  • 3
8 Comments
 
LVL 7

Expert Comment

by:valmatic
ID: 39659624
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
 

Author Comment

by:mjsimmer
ID: 39659628
No just trying to open it.
0
 
LVL 7

Expert Comment

by:valmatic
ID: 39659655
it is not going to just open in excel 2010, you need to be in excel and use one of the ways above.
0
 

Author Comment

by:mjsimmer
ID: 39659667
Under Manage templates if I try to open it I get an error that the file format is invalid.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 7

Expert Comment

by:valmatic
ID: 39659670
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
 

Author Comment

by:mjsimmer
ID: 39659970
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
 
LVL 7

Expert Comment

by:valmatic
ID: 39660296
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
 
LVL 12

Accepted Solution

by:
Harry Lee earned 500 total points
ID: 39667580
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now