Xlusrgal.xls

[Guest]

I have several macro's with that besides doing many other things insert
charts from data on the worksheet. In one particular long macro it starts
with maybe 10 open files collects data from the files and combines the data
in a new workbook and creates charts. When I go to close the xlusrgal hanges
up. I do not open xlusrgal but it must get opened when my macro calls a
custom chart. The send error report comes up.

Also, dealing with this same xlusrgal issue. Now when I try to add a new
custom chart I get the following message boxes:

Message Box 1: A formula or sheet you want to move or copy contains the
name "Notes" which already exists on the destination worksheet. Do you want
to use this version of the name? . To use the name as defined in the
destination sheet, click Yes. . To rename the range referred to in the
formula or worksheet, click No, and enter a new name in the Name Conflict
dialog box.

Message Box 2. A formula or sheet you want to move or copy contains the
name "Run_Summary", which already exists on the destination worksheet. Do
you want to use this version of the name? . To use the name as defined in
the destination sheet, click Yes. . To rename the range referred to in the
formula or worksheet, click No, and enter a new name in the Name Conflict
dialog box.

Any help will be appreciated.... Thank you... Windows 2000, office xp.

 

[Peter T]

I have several macro's with that besides doing many other things insert
charts from data on the worksheet. In one particular long macro it starts
with maybe 10 open files collects data from the files and combines the data
in a new workbook and creates charts. When I go to close the xlusrgal hanges
up. I do not open xlusrgal but it must get opened when my macro calls a
custom chart. The send error report comes up.

It is normal for Xlusrgal.xls to open if you are applying a UD chart type. I
find this can remain visible in the VBE but without causing any problems.
What error do you get.

Also, dealing with this same xlusrgal issue. Now when I try to add a new
custom chart I get the following message boxes:

Message Box 1: A formula or sheet you want to move or copy contains the
name "Notes" which already exists on the destination worksheet. Do you want
to use this version of the name? . To use the name as defined in the
destination sheet, click Yes. . To rename the range referred to in the
formula or worksheet, click No, and enter a new name in the Name Conflict
dialog box.

Message Box 2. A formula or sheet you want to move or copy contains the
name "Run_Summary", which already exists on the destination worksheet. Do
you want to use this version of the name? . To use the name as defined in
the destination sheet, click Yes. . To rename the range referred to in the
formula or worksheet, click No, and enter a new name in the Name Conflict
dialog box.

I'm guessing the source data for some of your series is a named
formula/array, rather than from cells. When you add a chart with a defined
name to Xlusrgal.xls it will also add the Name. This name will persist in
Xlusrgal.xls even if you subsequently delete the UD chart.

When you add another chart with the same name you get this type of message.
If you accept the prompt the old name will be overwritten by the new name,
incl whatever it "refers to", or if you decline the newly added chart will
include the old name. Normally it doesn't matter either way, as the data is
of no importance, purely to help define the chart type.

However I think best not to add a charts with Name's to Xlusrgal.xls for the
simple reason they are not easily deleted when no longer required. Replace
the named data with minimum necessary in order to define the chart.

Assuming Xlusrgal.xls contains at least one chart you can open it in the
normal way, delete any unused names (if sure) or first replace named data in
series formula(s) with something like
=SERIES(,,{1,2,3},1)

Save & close the file, naturally having made a backup before doing anything!

Regards,
Peter T

 

[Peter T]

Actually there's more relating to Names in Xlusrgal.xls. It's not only named
formulas used in series in the chart that's being added as a UD chart type
(as I suggested previously). Seems any Named formula in the workbook gets
added to Xlusrgal.xls, eg a dynamic named range. An "ordinary" name does not
get added.

So when adding a UD chart, if "MyName" exists in Xlusrgal.xls - on adding a
chart where MyName also exists in the Workbook but its Referto is not the
same as that in Xlusrgal.xls, then a message will appear.

Not sure if this is an intended design feature but not nice.

Regards,
Peter T