If you record a macro while creating a histogram (data analysis add-in), it
will not run, with error 1004 "ATPVBAEN.MLA cannot be found". Same happens
with correlation. I have searched my computer: this file does not exist.
Am I looking at an undocumented Microsoft bug? PS This is in Excel 2002 and
2000, I don't know about 2003.

ATPVBAEN.XLA which is the Analysis Toolpak for VBA, should be found in the
Office\Library\Analysis folder.

If not there, perhaps go to Control PanelAdd/remove and Select Office 2003 and
"Change".

Go through the steos and see if you can get ATPVBAEN.XLA installed.

You will most likely need the CD.


Gord Dibben MS Excel MVP

On Tue, 8 Aug 2006 19:26:38 -0700, bjorn
wrote:

If you record a macro while creating a histogram (data analysis add-in), it
will not run, with error 1004 "ATPVBAEN.MLA cannot be found". Same happens
with correlation. I have searched my computer: this file does not exist.
Am I looking at an undocumented Microsoft bug? PS This is in Excel 2002 and
2000, I don't know about 2003.