Skip to content
logo Knowledgebase

Error: Unspecified Error when exporting an inquiry to Excel

Created on  | Last modified on  Highlight Matches

Summary

This article provides workarounds and resolutions for the message “Unspecified Error” when exporting an inquiry to Excel.

Description

This provides resolutions for the longer message: 

 

Error: "The file format and extensions of '[filename].xls' don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open it. Do you want to open it anyway?" (when opening an .xls file created from Inquiry Export to Excel)

 

This resolution also works if the Export to Excel button is missing after upgrading.

Cause

Resolution

CAUTION: Sage Customer Support cannot assist with issues related to third-party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions. Refer to our Scope of Support document for details. For assistance, contact your Sage business partner, network administrator, or accountant. 

This Sage 300 Construction and Real Estate feature relies on Microsoft Excel controls to export the query to Microsoft Excel. This problem is due to an issue with the Excel installation; an Excel update, or other factors on the system may cause this control to malfunction. Sage Support will be unable to troubleshoot. Below are workarounds. Contact Microsoft Support for assistance with Microsoft Excel.

To verify if you are running a 32-bit or 64-bit version of office open any Office application and navigate to File Office Account About The end of the first line in the About window will either say 32-bit or 64-bit.


Possible Temporary Workaround: Use Print to file

  1. In the Inquiry window, click Printer.
  2. Click the Printer Setup button.
  3. Check the Print to file option.
  4. Click the Select File button.
  5. Change the Save as type to Microsoft Office Excel Workbook.
  6. Type a File name.
  7. Click Save.
  8. Click OK.
  9. Click Start.
Potential Quick Fix: May not always work and requires Administrator permissions
  1. Close completely out of Sage and any Office apps you may have open.
  2. In the Windows search bar type Printers and select Printers & Scanners.
  3. Select TS PDF Generator and choose to remove the device.
  4. Open File Explorer and navigate to: \\YourSageServerName\Timberline Office\9.5\ACCOUNTING\WinInst\Prerequisites\PDF Converter
  5. Right click on RunAmyuniInst.exe and run as administrator.
  6. Open 300CRE and try to export again.


Solution for 32-bit Office:

  1. Close completely out of Sage and any Office apps you may have open.
  2. In the Windows search bar type Printers and select Printers & Scanners.
  3. Select TS PDF Generator and choose to remove the device.
  4. In the Windows search bar, type appwiz.cpl and press Enter.
  5. Locate your Microsoft Office Install.
  6. Right click on the Office install in the program list and select Change.
  7. Select Online Repair then wait for the process to complete. Quick Repair does not work.
  8. After the process completes open File Explorer and navigate to: \\YourSageServerName\Timberline Office\9.5\ACCOUNTING\WinInst\Prerequisites\PDF Converter
  9. Right click on RunAmyuniInst.exe and run as administrator.
  10. Open Sage and attempt to export again.


Solution for 64-bit Office:

IMPORTANT:

  • You will need to have administrative access and the 32-bit version of your Office product to perform the following steps
  • Just uninstalling and reinstalling Office WILL NOT RESOLVE this issue
  • Please follow the steps below closely so as not to waste your time redoing
  • Logging in as an administrator and using that account will have the greatest change of resolving your issue completely
  • If possible, it is recommended that you have your IT person\company complete these steps

UNINSTALL

  1. Close completely out of Sage and any Office apps you may have open.
  2. In the Windows search bar, type appwiz.cpl and press Enter.
  3. Locate Sage 300 Construction and Real Estate Client and click Uninstall.
  4. Open your internet browser and paste the following link: https://support.microsoft.com/en-au/office/uninstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8
  5. Expand Option 2 and download the Microsoft 365 Uninstall Support Tool.
  6. Right click and download the tool and Run as administrator the follow the prompts to uninstall Microsoft Office.
  7. Reboot the workstation.

REINSTALL

  1. Install the 32-bit version of Microsoft Office.
  2. Once Office is installed open File Explorer and browse to your server Timberline Office share: \\YourServerName\Timberline Office
  3. Right click on the Sage300CRE ACCT Client install shortcut in the Timberline Office folder.
  4. Select Run as administrator then follow the prompts to install.
  5. Toward the end of the 300CRE installation you will be required to reboot. Make sure you login with the same account you used for the first half of the install.
  6. Open Sage and attempt your export again.



Need more help?

Chat now