I have 2 large spreadsheets which were created in Excel 2003. One spreadsheet has formulas in numerous cells which pull in data from the other spreadsheet. I have now upgraded to Excel 2007 and saved the files as xlsx. The formulas pulling in data from one spreadsheet to the other don't always work. Settng to Auto Calc doesn't work. Any idea why or how to fix?