Error: "Unspecified Error" when exporting an inquiry to Excel

Summary

When I export an inquiry from Sage 300 CRE to Excel, I get the message "Unspecified Error".

Description

Alternate 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

Causes include, but aren't limited to:

  • Microsoft Office Updates
  • Using the 64-bit version of Office
  • Pending Updates Requiring Reboot

Resolution

CAUTION: Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.

Versions 25.1 and later

As of Version 25.1, the file extension for inquiries exported to Excel is .xlsx. We no longer use the extension .xls.

Versions 24.3 and earlier

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

This Sage 300 Construction and Real Estate feature relies on Microsoft Excel controls to export the query to Microsoft Excel. This occurs due to an issue with the Excel installation, an Excel update, or other factors on the system. Sage Support can't troubleshoot. Below are workarounds. Contact Microsoft Support for assistance with Microsoft Excel.

Verify if you're running a 32-bit or 64-bit version of Microsoft Office before choosing an option below to resolve.

Possible Temporary Workaround

Use Print to file instead.
  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 out of Sage and any Office apps you 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 browse to:
    • \\YourSageServerName\Timberline Office\9.5\ACCOUNTING\WinInst\Prerequisites\PDF Converter
  5. Right-click RunAmyuniInst.exe and run as administrator.
  6. Open 300CRE and try to export again.

Solution for 32-bit Office

  1. Close out of Sage and any Office apps you 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 the Office install in the program list and select Change.
  7. Select Online Repair then wait for the process to complete. Quick Repair doesn't work.
  8. When the process completes, open File Explorer and browse to:
    • \\YourSageServerName\Timberline Office\9.5\ACCOUNTING\WinInst\Prerequisites\PDF Converter
  9. Right-click RunAmyuniInst.exe and run as administrator.
  10. Open Sage and attempt to export again.

Solution for 64-bit Office

Information

  • You'll need to have administrative access and the 32-bit version of your Office product to perform the following steps
  • Just uninstalling and reinstalling Office won't resolve this issue
  • Follow the steps below closely so you don't have to redo them
  • Log in as an administrator and use that account for the best effect at resolving the issue
  • We recommend that you have your IT person\company complete these steps

Uninstall

  1. Close out of Sage and any Office apps you 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:
  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. When Office finishes installing, open File Explorer and browse to your server Timberline Office share:
    • \\YourServerName\Timberline Office
  3. Right-click 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'll need to reboot. Make sure you log in 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

 

 







 

Solution Properties

Solution ID
224924450061091
Last Modified Date
Thu Jul 20 19:39:03 UTC 2023
Views
0