Exporting from Quickbooks 2017 Pro to Excel 2010

CC1477 · ‎February 03, 2020

I just got a new computer. IT installed Office 2010. I have Quickbooks Pro 2017. I am unable to export any files to excel. Options are all grayed out. Since it was a new computer, it had 365 on it, which was removed/disabled. Can this be part of the problem? It does not appear that Pro 2017 is compatible with 365, although I am using Office 2010. Any suggestions?

Rasa-LilaM · ‎February 04, 2020

Thanks for adding more details about your concern, @CC1477.

QuickBooks 2017 is compatible with Office 2010 and works for both 32 and 64 bit. However, we also support Office 365, but it has to be installed locally.

Since your QuickBooks is already up to date, let’s try performing another troubleshooting to resolve the issue.

First, repair Microsoft Office to start on a clean slate. I recommend visiting this website to view the detailed instructions: Repair an Office application.

Next, open your company file and then try exporting a report. If the Export is still greyed out, toggle the Windows UAC settings to on and off.

This will remove anything that’s blocking the feature from working. Here's how:

Press Windows+R on your keyboard to open the Run window.
In the field box, enter Control Panel to open the User accounts screen.
Click the Change user account control settings link.
In the User Account Control Settings dialog, move the slider to Never Notify and then choose OK.

Then, restart the computer for the changes to take effect. If none of these suggestions work, follow the recommended steps in this article and perform Step 5: Fix export to Excel issues in QuickBooks Desktop article.

Keep me posted if you need some help with the product. Please know I’ll be right here ready to assist further. Have a good one.

View solution in original post

Michael K · ‎February 03, 2020

Hi there, @CC1477. Thanks for reaching out to the Community.

I'm here to help you get your information exported to Microsoft Excel 2010. Let's make sure your QuickBooks 2017 version is on the latest release. It's super easy to check and only takes a moment. Take a look:

Go to the Reports menu and open any report on the list.
Select the Excel button. All export options, including Excel, should be available.

If you continue to have issues after performing an update, I recommend checking the system requirements for QuickBooks Desktop 2017 to ensure your computer and Excel version meet the requirements: System requirements for QuickBooks Desktop 2017 and Enterprise Solutions 17.0

Please keep me updated by using the Reply button below. I'll be here for you should you have any other questions.

CC1477 · ‎February 04, 2020

Hello,

Thank you so much for your response. I am currently on Release R15P so that sounds like the latest update for me. Unfortunately, when I go to reports and bring up a report to export to excel, all is grayed out except the option to “create a comma separated values (.csv) file.

I have a new computer – which is when this problem started. I before, was able to export my reports into excel files. According to system requirements Office 2010 should work. I believe it is on 32 bit. Only think I can think of is the computer came with a trial of the Office 365 but I do believe our IT guy removed that. I am going to have him look at that again. Do you have any other ideas? Do you think an upgrade to Quickbooks Pro 2019 might be what I need? I don’t want to make a purchase and find it was futile.

CC1477 · ‎February 04, 2020

I apologize if this comes through twice.

Hello,

Thank you so much for your response. I am currently on Release R15P so that sounds like the latest update for me. Unfortunately, when I go to reports and bring up a report to export to excel, all is grayed out except the option to “create a comma separated values (.csv) file.

I have a new computer – which is when this problem started. I before, was able to export my reports into excel files. According to system requirements Office 2010 should work. I believe it is on 32 bit. Only think I can think of is the computer came with a trial of the Office 365 but I do believe our IT guy removed that. I am going to have him look at that again. Do you have any other ideas? Do you think an upgrade to Quickbooks Pro 2019 might be what I need? I don’t want to make a purchase and find it was futile.

Rasa-LilaM · ‎February 04, 2020

Thanks for adding more details about your concern, @CC1477.

QuickBooks 2017 is compatible with Office 2010 and works for both 32 and 64 bit. However, we also support Office 365, but it has to be installed locally.

Since your QuickBooks is already up to date, let’s try performing another troubleshooting to resolve the issue.

First, repair Microsoft Office to start on a clean slate. I recommend visiting this website to view the detailed instructions: Repair an Office application.

Next, open your company file and then try exporting a report. If the Export is still greyed out, toggle the Windows UAC settings to on and off.

This will remove anything that’s blocking the feature from working. Here's how:

Press Windows+R on your keyboard to open the Run window.
In the field box, enter Control Panel to open the User accounts screen.
Click the Change user account control settings link.
In the User Account Control Settings dialog, move the slider to Never Notify and then choose OK.

Then, restart the computer for the changes to take effect. If none of these suggestions work, follow the recommended steps in this article and perform Step 5: Fix export to Excel issues in QuickBooks Desktop article.

Keep me posted if you need some help with the product. Please know I’ll be right here ready to assist further. Have a good one.

CC1477 · ‎February 05, 2020

Thank you thank you thank you!

Topics

Training

Community

Resources

Exporting from Quickbooks 2017 Pro to Excel 2010