We use Excel 2003 a lot on our server. Recently we have started to find speadsheets with auto calcualtion switched to manual. My questions are how can this option be switched on i.e. does it come from a template. Is there an easy way to find all occurrances of spreadsheets with this indicator swtched to manual. Finally, anyway of overriding the manual indicator so that automatic calculation so it is always switched on...

many thanks for your assistance with this...

Peter