dstanton007
asked on
Quickbooks cannot Send Report as Excel and all Advanced Excel Options are disabled.
Issue #1:
When exporting a report via Quickbooks to Excel, the only option available is to export to a .csv file. All other options, including options under "Advanced.." are greyed out and disabled. Exporting to new a .csv worksheet works correctly, but we are unable to update existing worksheets because we cannot select the option to do so. Why would these options be unavailable?
Issue #2:
When attempting to "Send Report as Excel" under "Email", the following error is displayed:
The steps we have done are:
1.) Removed Office Suite, rebooted PC. Re-installed Office 2016.
2.) Repaired QuickBooks.
3.) Downgraded Microsoft Office 2016 to the supported Office 2013.
4.) Removed QuickBooks, rebooted PC. Re-installed QuickBooks.
This is running on Windows 7 64bit, Quickbooks Premier 2013, and Office 2013 64bit.
Thanks, I appreciate any assistance/insight on this issue.
When exporting a report via Quickbooks to Excel, the only option available is to export to a .csv file. All other options, including options under "Advanced.." are greyed out and disabled. Exporting to new a .csv worksheet works correctly, but we are unable to update existing worksheets because we cannot select the option to do so. Why would these options be unavailable?
Issue #2:
When attempting to "Send Report as Excel" under "Email", the following error is displayed:
The steps we have done are:
1.) Removed Office Suite, rebooted PC. Re-installed Office 2016.
2.) Repaired QuickBooks.
3.) Downgraded Microsoft Office 2016 to the supported Office 2013.
4.) Removed QuickBooks, rebooted PC. Re-installed QuickBooks.
This is running on Windows 7 64bit, Quickbooks Premier 2013, and Office 2013 64bit.
Thanks, I appreciate any assistance/insight on this issue.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
John
I just spent all day at a client and exported numerous reports directly to Excel. Worked fine. Did you try 32-bit Office?
ASKER
John Hurst,
Installing the 32bit variant of Office 2013 solved BOTH issues!
Thank you!
Installing the 32bit variant of Office 2013 solved BOTH issues!
Thank you!
Good news. I figured that would be the issue. Thanks for the update.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
