I have 1.5 Mbyte workbook controlling data acquisition (VXI/GPIB) which
uses VBA and calls to DLL's containing HP low level routines.

Over time opening this workbook became more time consuming, resulting in a
staggering 15 minutes right now.

There are no Auto_Open macros. The Open event is not used on workbook or
sheet level. Disabling all macros does not improve the situation. Closing
the workbook takes just as long as opening it. There is virtually nothing
to recalculate as the workbook (master copy) is empty except for some
boiler plate text, formatting and the VBA code. Switching to manual recalc
does not help.

The PC is not out of diskspace (33% free), defragmentation status is OK.
On a different PC the workbook opens in a flash.

Does anyone know of diagnostics code to be put in the open event so that I
can see what is going on whilst the workbook is being opened.

Thanks a bunch.