I have a file that links in several different datasources. What I am doing is updating all my sources, running all my calculations then producing "results" sheets. I have several seperate reports being generated from the same data. I am copying the worksheet into a new workbook then saving, emailing, then going onto the next. Problem is when the users open that file their calculation is set to manual because I am manually calculating everything to speed up processing time. If i enable auto calculation after copying the worksheet it calculates my entire workbook, then saves, and goes onto the next. Each time it auto calculates it takes 15 minutes. With manual calc its 2 minutes. How can i make it so that my main file always has auto calc off but make it so that when users open the seperate file auto calc is enabled?