View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Disabling Autocalculation when opening CSV files

In xl2003, I can use:
tools|Options|calculatation tab
and change the calculation mode to manual.

johnmasvou wrote:

Every time I open a csv file it recalculates every possible formula in my
workbook, taking forever to open it. Is there any way to disable this from
the Excel menu options rather than in VBA?


--

Dave Peterson