I have a .xls file which calls a UDF function from an xla addin (I will call
the workbook...MyFile.xls). MyFile.xls also has an Auto_Open procedure.
When run normally MyFile.xls works just fine.

However, when run as a scheduled task, the task hangs awaiting someone to
answer the update links question. The Scheduled Tasks Manager appears to
open the MyFile.xls workbook BEFORE all Add-ins are installed (including the
UDF.xla that it needs).

I found that if the user DOES NOT have the add-in "Analysis ToolPak -
VBA/ATPVBAEN.xla" installed, they will receive the "Update Links" question.

If they do have the "Analysis ToolPak - VBA/ATPVBAEN.xla" installed, they DO
NOT receive the "Update Links" question.

When running the MyFile.xls from the Scheduled Task Manager -- once the user
has the "Analysis ToolPak - VBA/ATPVBAEN.xla" installed, ALL Add-ins load
BEFORE the MyFile.xls workbook is opened (This is not the case if the
ATPVBAEN.xla is not installed. The MyFile.xls opens before all .XLAs, COMs,
etc. are opened).

Can anyone tell me what the "Analysis ToolPak - VBA/ATPVBAEN.xla" is doing
that would cause all .XLAs, COMs, etc. to load prior to the MyFile.xls
workbook being opened when called from the Scheduled Task Manager? I would
rather not use the ATPVBAEN.xla if it is not required for the workbook.
However, this situation is forcing me to have it installed even though it is
not needed for the VBA code.

Thank you for your assistance.

--
Thx
MSweetG222