Out of Memory error in Spreadsheet IQ


You receive the following error when you run Workbook Analysis on a workbook with Microsoft Prodiance Spreadsheet IQ: 

Unexpected error while analyzing current file...Exception of type 'System.OutOfMemoryException' was thrown.


There is a 2 GB memory limitation of 32-bit Windows that is reached when you analyze a large or complex workbook with Spreadsheet IQ.


There are two solutions to avoid the 32-bit Windows operating system limitation: 
  • Install Office 2010 suite 64-bit version on the computer. (NOTE: Operating system would have to be Windows 7 64-bit) 
  • Break up the Excel workbook into smaller workbooks that can be compared individually.


文章識別碼:2723589 - 最後檢閱時間:2013年1月30日 - 修訂: 1