One more,

Use a dummy workbook to...
open the fifteen files
open the master workbook.
close itself.

Jim Cone



"Jim Cone"
wrote in message
Lauri,
Some ideas if you want to experiment...
Use this code line first: "ThisWorkbook.UpdateRemoteReferences = False"
Or this line: Application.Calculation = False
-or maybe-
Use a dummy workbook that has calculation turned off to open your workbook.
-or maybe-
Put your code in an Auto_Open sub (in a standard module, not in the
ThisWorkbook module) and see if you get different results.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)