<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
If you only need pivot data be auto refreshed when opening a file, please set the pivot table’s data option to “Refresh on open” when you create the file with Ms Excel 2007. This will force the pivot table to auto refresh data when the file is opened in Ms Excel.
“If I have a formula somewhere that uses the table count function, the spreadsheet will throw an exception when I try to open and save it?”
Aspose.Cells will not throw an exception if you open and save a file containing unsupported formula. But if you open the file and call Workbook.CalculateFormula(), some exception may be thrown out. You can also use Workbook.CalculateFormula(true) to ignore calculate formula error, it means exceptions will be swallowed.