There are five situations in which this error message comes up most regularly.
1) You have a damaged PDF file – If this is the case, you can try to digitally reprinting the file as the PDF may be internally corrupted or damaged. To reprint, you'll need to open the file in Adobe Acrobat, or a similar program that can print to PDF, such as our Sonic PDF Creator. There are also free software solutions available online for printing PDFs. After regenerating the PDF file, you can open it in Able2Extract and try the conversion again. In most cases, regenerating the PDF can fix damaged or lost information in the PDF file.
2) The file is too large – This happens with large Excel files especially - Excel runs out of memory. Try using the “Edit”->”Select Page Range” option to convert smaller selections at a time. You can also break the document up by doing a digital re-print as outlined above and selecting your page range. Also, rebooting your PC may help.
3) If you can’t convert ANY PDF files to Excel, then MS Excel may not be properly installed, or the installation settings where ruined post-installation. In this case, the easiest solution is to re-install MS Office, or try the following:
a) Press the Start button (in the bottom left corner) and select the Run command from the Menu.
b) Once the Run dialog box opens, type excel /regserver in the Open field of the dialog and press OK (there should be a space between excel and /regserver ). After that, try the conversion again.
4) The page dimensions exceed 20”x20” – use a PDF virtual printer (i.e. Adobe Acrobat) to resize/recreate the PDF file (this applies to scanned PDF files only)
5) The error is a result of the delivery package (i.e. Citrix) used to deliver the application to the desktop; a local manual install will allow conversions to work.
Most times, this error is related to file size. Prior to Excel 2007, Excel spreadsheets could contain only 65,000 rows. In cases of very large PDF documents that require conversion from PDF to Excel, it is possible that the number of rows in Excel could be exceeded. If the PDF you are converting exceeds these limitations, Excel will run out of virtual memory and crash, resulting in this Fatal Error #24 message.
What you will need to do is break the document up prior to importing it into Able2Extract. Upgrading your software to our current version will also resolve the issue, as the current version is built on the parameters of MS Office 2007, which does not have automation.
This article refers to Able2Extract and Able2Extract Professional.