Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/170794

From BetaArchive Wiki
Knowledge Base

Article ID: 170794

Article Last Modified on 4/17/2006


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q170794


When you attempt to create a user-defined custom chart type in Microsoft Excel 97, the following error message appears:

Microsoft Excel cannot save the user-defined chart gallery in the folder specified. Save the gallery elsewhere now, and use the Gallery Location tool to specify a different folder.

When you click OK, you are prompted to save the Xlusrgal.xls file in the default documents folder (usually C:\My Documents).


This problem occurs when you do the following:

  • You log on to Microsoft Windows as one user, install Microsoft Excel 97 (or Microsoft Office 97), and then chose the "Run from Network Server" option. -and-

  • You log off, and another user logs on to Microsoft Windows, runs Microsoft Excel 97, and then attempts to create a user-defined chart type.


To correct this problem, install Microsoft Excel 97 Service Release 1 (SR-1).


Microsoft has confirmed this to be a problem in Microsoft Excel 97. This problem was corrected in Microsoft Excel SR-1.

For additional information about SR-1, please see the following article in the Microsoft Knowledge Base:

172475 OFF97: How to Obtain and Install MS Office 97 SR-1


In Microsoft Excel, you can create a custom chart type. With a custom chart type, you can specify the custom formatting and options you want to include for a particular chart style. Custom chart types you add are stored in the Xlusrgal.xls file in the location specified in the GalleryPath registry setting for Microsoft Excel 97.

The gallery location tools allow you to specify where Microsoft Excel and Microsoft Graph look for custom chart gallery files. You can obtain this free utility on the Web. To do this, use a Web browser to go to the following Microsoft Web site:

For additional information about creating custom chart types, please see the following article in the Microsoft Knowledge Base:

161348 XL97: Setting Default and User-Defined Chart Types

Additional query words: sr1 XL97 network server workstation rns Microsoft Excel Gallery Location tool Graph

Keywords: kberrmsg kbbug kbfix kbchart KB170794