Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
user-defined charts in Excel 2007 | Charts and Charting in Excel | |||
Excel User Defined Functions + Link.How to stop #Value after save | Excel Discussion (Misc queries) | |||
User-defined charts | Charts and Charting in Excel | |||
Save user-defined chart types in a shared Excel template? | Charts and Charting in Excel | |||
Can not add user-defined charts | Charts and Charting in Excel |