Cannot Export a Report from Sage to Excel
Sage is no doubt an awesome accounting software, which keeps updating itself to give the best user experience. Sometimes while exporting a report to excel won’t success and this error or issues can be harmful to the users. The below article helps you to remove the issue. It is always advisable that if you face any doubt please contact Sage experts.
Below are the causes which can be the reasons behind this issue:
- Printer Device conflict
- Microsoft Excel is not configured to start a new worksheet with the normal view
- MS office 365 or office clerk to run is installed
- Incompatible office version
- User account control blocking access to Excel
- The print spooler service is not running
- Program is running is a hosted network
- No default printer is selected
- Temporary files not extracting properly
- Report option changed
Solutions for Export a Report from Sage to Excel
Section 1 – Incompatible version of Microsoft office
Microsoft office version may be not compatible with the sage, in this case, just check and install the latest version of the MS Office which is compatible with the sage.
Section 2 – Report Header options
- Open the report in sage 50
- select the excel button
- In copy report to excel, select send the header to page setup in Excel box
- Check if you are now able to generate a copy of the report to excel
Section 3 – User Account Control Blocking access
Now disable the user account control blocking access
Section 4 – Microsoft Excel default view for new sheets
verify in excel the default view for new sheets is Normal View
In excel 2007 >>click the Microsoft button, excel options click popular
In the when creating new workbooks section, select the normal view from the default view for new sheets drop-down list >>Click ok
In excel 2010 and 2013:
Click File>>options>>select the general section. When the creating new workbooks section, select a normal view from the default view for new sheets drop-down list, click Ok
Section 5 – Delete the files in Temp directory
Press Windows +R keys >>type %temp%>>Click ok>>Press Ctrl+A keys to highlight all files and folders>>Right click one of the highlighted files in the same location and then click Delete>>skip any files which can not be deleeted>>check the reports end to excel
Section 6 – Permission to write to Temp directory
open computer or this PC>>Go to C:\Users\[User Name]\App Data\Local>>Right click Temp>>select properties >>Select security tab>> to check if the user has full control or read access and write access to folder>>Click OK>>check if the report can send to excel
Section 7 – Printer conflict
Open devices and printers>>In windows XP click start, printers>>In windows vista and 7 click start, devices and printers>>In Windows 8 press windows +X keys >>click devices and PRinters>>If no printer is there marked as default, then right-click a printer and then select Set as default printer >>Try to send the report to excel again>>if the error still comes to go to Devices and printers>.right click a different printer instead f current default printer and click Set as default printer >>open sage>>Now try to send the report to excel, if still, an error comes to repeat the steps
Do right click on each installed printer and select Delete or remove device >>dont remove the sage 50 email writer reinstall each printer, one at a time>>>try to send the excel after every reinstall to find which printer is creating the conflict. Once the conflict printer is found, install a generic driver for it and if alternate is not available to refer the below steps
- Export to.CSV format
- Click File, select Import /Export
- select the proper category
- Choose the desired list or journal
- Click export
- send the export potions and filters as desired and then click ok
- Open the exported file from My document with the excel
- use the sent to the button
- Click Lists, the appropriate section, and the desired record or transaction type
- Click settings
- Remove or add a column
- Click OK
- Click send to excel
Section 8 – Open Microsoft Excel first
- Open the Excel before opening the report
- Check if you can export the report to excel
Contact
For any assistance dial Sage 50 technical support number +1-844-871-6289 and get the sage support assistance immediately. You can also email at support@accountingadvice.co and one of the sage experts contact you with the relevant information. The sage team is available 24*7 to assist you with all possible solutions with sage and it is one-stop-shop for all your issues related sage.
Post navigation
Report Your Issue
(Didn't find what you were looking for! Report your issue and get customized help from our Sage experts.)