Calculation wont happen (manual or automatic) until you open the excel file. So if you are already using the workbook activity in project change it to excel scope or if you using excel scope check the calculation settings in Excel app for the users. It should be automatic.
More info at here