Hello. Since the usage of Version 2010R2 ( actual version 10.5.111054.0 ) we get an error in some reports.
With version 2009 the reports worked fine.
May be there is a solution.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hmmm, this is strange. What Jet is actually trying to do when the OutOfMemoryException occurs is auto fit columns. I have never seen Jet run out of memory while doing this. Jet is actually going through all the values in the used range of row 1 and column A of each worksheet, looking for the "Fit" keyword and telling Excel to auto fit that column or row.
Is the report file itself disproportionately large? This can be a sign of workbook corruption. Sometimes when a report becomes corrupted, the used range grows to include the entire worksheet, which could cause Jet was trying to look through a very large list of values and running out of memory. It also often causes the report file to grow very big even when there is not much data in it, which is why I ask whether it is very large.
If the workbook is corrupted, you can probably create a new workbook and copy the formulas out of the original workbook into the new workbook. Another way to fix corruption is to save the workbook as HTML and then save it back as an Excel file. If you are using Office 2007 or 2010, make sure to save the workbook as XLSX, not XLS since saving as XLS will cause newer versions of Excel to run in compatibility mode, which cause unexpected behavior.
Regards,
Hughes
Please sign in to leave a comment.