View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default 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