Turn off Autocalc before opening sheet
 

hi

07 seems to default to auto calc which I can only turn to manual once I open
the sheet. Problem is the sheet links to a library I dont have access to so
all the figures are NA - how do i change setting so calculation is manual for
all Excel before i open a this workbook

thanks
--
Kevin