I have a module that loops an open several hunderd other excel data files. Although I used the command

Application.Calculation = xlCalculationManual

it is still calculating eachtime one of these files is opened. Is there someting I can write in the module that will not allow the calcualting (which seriously slows down the subroutine.

Thanks