LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default cannot save user-defined charts in Excel 2003

When I try to save a user-defined chart in Excel 2003 I get this
error: "Microsoft Excel cannot save the user-defined chart because
the chart gallery file is currently in use or does not exist. Click
OK, and then change the gallery file name or location before you
save."

Then it opens a Save dialog that tries to save the worksheet I created
the chart in, which goes nowhere.

I do not have any xlusrgal.xls file on my PC, but Excel is convinced I
have one, and that it is open and busy, thank you, whenever I want to
save a chart.

I have tried creating my own xlusrgal.xls file and putting it in the
right location (C:\Documents and Settings\accountname\Application Data
\Microsoft\Excel) but this does not fool Excel.

I have done a couple of Excel Repairs, have uploades Service Pack 3,
etc., but to no avail.

Interestingly, the exact same functionality works perfectly in
Microsoft Graph in PowerPoint, which uses the same Chart Type...
dialog as Excel, but saves the chart in a file called GRUSRGAL.GRA.

I have found very little documentation of this problem, and no
solution, in Groups or anywhere else. A few people have written in
about it over the years (the problem appears to go back at least to
Excel 2000, if not 97), but no fixes have been offered.

I have a very recent fresh install of Office on a new computer and do
not think this functionality has ever worked properly, but perhaps I
corrupted some file along the way.

Any help on this would be most appreciated.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
user-defined charts in Excel 2007 Laura Battarbee Charts and Charting in Excel 5 August 1st 07 05:14 AM
Excel User Defined Functions + Link.How to stop #Value after save DaveH Excel Discussion (Misc queries) 2 July 14th 07 01:17 AM
User-defined charts Fredrik E. Nilsen Charts and Charting in Excel 16 December 13th 06 06:37 PM
Save user-defined chart types in a shared Excel template? graphicslady Charts and Charting in Excel 7 September 7th 06 02:07 PM
Can not add user-defined charts David DeRolph Charts and Charting in Excel 4 May 16th 06 09:44 PM


All times are GMT +1. The time now is 09:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"