View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JakeyC JakeyC is offline
external usenet poster
 
Posts: 107
Default Manual Calculation not working?

I could be wrong, but I don't think stopping calculation will stop
automatic refreshes of external queries. See if you can right-click the
data and select 'properties' - if so, disable automatic refresh.
Otherwise, check what your add-in has actually done and finally check
that the workbook has no code that runs on opening that could revert
excel to your original settings.