Microsoft KB Archive/229465

= XL2000: Custom Add-In Overwritten When You Load Add-In =

Article ID: 229465

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q229465



SYMPTOMS
In Microsoft Excel, when you load an add-in, existing add-in files may be overwritten.

Specifically, the following files may be overwritten:
 * In the \Office\Library folder: Html.xla, Acclink.xla, Autosave.xla, Sumif.xla, Eurotool.xla, Lookup.xla, Tmpltnum.xla, Wztemplt.xla, Updtlink.xla
 * In the \Office\Library\Analysis folder: Atpvbaen.xla, Funcres.xla, Procdb.xla
 * In the \Office\Library\Msquery folder: Xlodbc.xla, Xlquery.xla
 * In the \Office\Library\Solver folder: Solver.xla



CAUSE
This behavior may occur when you create an add-in and then load that add-in for the first time. When loading the add-in, Excel may not recognize the existing add-in file and may overwrite it.



WORKAROUND
To work around this behavior, modify the add-in so that the Modified date and time of the add-in file is different than its Created date and time. To do this, when you save your add-in, resave it a second time. This will cause the Modified date and time to be later than the Created date and time.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbbug kbpending KB229465

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.