In general, you should use a recent version of Microsoft Excel when working with Spreadsheet reports, and when creating custom reports with templates, you should use the same version of Excel for both creating and viewing the template. Check the System Requirements document for the version of Excel that aPriori has tested Spreadsheet Reports against (as of this writing, we have tested against Excel 2010).

With the exception of the Component Sourcing report, all aPriori report templates are .xlsx files, so if you are using Excel 2003, you should upgrade to Excel 2010 when using .xlsx-based reports.

Note that template-based reports work properly when the OS running the report supports the same version of Excel on which the spreadsheet report template is based. For example, if you build a spreadsheet report and create a template for it with Excel 2010, then you should use Excel 2010 to view it. Problems may occur when the two versions are mismatched. You should not use Excel 2007, for instance, to open a template created on Excel 2010.

It is possible to view aPriori Spreadsheet reports in Google Sheets, however you may need to unhide tabs that are hidden in the reports. If you open a report in Google Sheets and the display looks incomplete or incorrect, try the following workaround: