+ Reply to Thread
Results 1 to 3 of 3

Unable to Edit Excel Chart Template

  1. #1
    Registered User
    Join Date
    06-25-2014
    Location
    St. Louis, Missouri
    MS-Off Ver
    2010
    Posts
    4

    Unable to Edit Excel Chart Template

    Hi people.

    I'm a fairly new engineering intern at a company and we use a lot of excel macros and chart templates to make charts from the data that we collect. We use one macro that calls a chart template to complete the job. A previous intern created the chart templates that we use today.

    Here's my issue: I want to make a small modification to the chart template that we've been using (literally all I want to do is to increase the size of a text box in the chart). The template is of course a crtx. file which I cannot open. How can I edit crtx. files? I am able to open up the template (mind it only the chart shows up with no data) when going to Excel -> Insert -> Insert Chart -> Manage Template -> Then I chose the template. I tried to edit that chart and then save that as a new template/overwriting it but that doesn't work. Do I need to find the original files that the previous intern used to create this template? I've tried that but no luck so far.

    Please let me know if I'm not explaining my problem clearly. Any help is greatly appreicated!!

    Thanks!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Unable to Edit Excel Chart Template

    You should be able to save a new template or even over wrtie the original. If not then maybe that folder is protected in some way to prevent accidental changes happening.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-25-2014
    Location
    St. Louis, Missouri
    MS-Off Ver
    2010
    Posts
    4

    Re: Unable to Edit Excel Chart Template

    Thanks for your reply.

    It could be that. Whenever I do save it as a new template and open it, nothing shows up. When I look at the file size, it says 0 KB. I did find a way to get around my inital issue but it would be nice to find out what for sure went wrong here..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 11-08-2012, 07:25 PM
  2. Unable to make an Excel template
    By chris8116 in forum Excel General
    Replies: 2
    Last Post: 02-18-2010, 03:11 AM
  3. Unable to edit Excel 2003 file
    By JohnIT in forum Excel General
    Replies: 3
    Last Post: 07-21-2006, 08:40 AM
  4. [SOLVED] I am unable to edit a comment in excel
    By Bill in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-26-2005, 05:15 PM
  5. Unable to open Template in Excel 2003
    By NYBrianK in forum Excel General
    Replies: 0
    Last Post: 01-05-2005, 06:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1