Tuesday, June 28, 2011

QuickBooks crashes Excel when running Payroll Report

I've had a few customers experience issues with exporting payroll reports in Quickbooks and causing Excel to crash. I outlined the fix that worked for them below.

The Fix...

Run the payroll export to Excel report like normal


Choose Options/Settings



 Check the selection that states, "Force alternate connection method provided for Excel 64-bit




Click OK

Deselect the option that reads, "Effective rates by item."
 
Select Get QuickBooks Data


4 comments:

  1. For the 2008 version, the company has also added import from Excel spreadsheets, additional employee time tracking options, pre-authorization of electronic funds and new Help functions. In June 2007, Intuit announced that QuickBooks Enterprise Solutions would run on Linux servers, whereas previously it required a Windows server to run.

    Thanks
    Michael
    legacy computer

    ReplyDelete