quickbooks reports export to excel "grayed out"

goldmineexpert
goldmineexpert used Ask the Experts™
on
I trying to run a report in QuickBooks and export to excel (not CSV) but the export window is all greyed out except for the CSV option. Any ideas why the rest of the options are greyed out?
Excel does not have any addins disabled.

thx bob

quickbooks reports export to excel "grayed out" qbooks export
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Business Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018
Commented:
Look in Edit -> Preferences -> Integrated Applications -> Company Preference tab and make sure nothing is being blocked (first two boxes should not be checked).

If Preferences are OK, then find the file reboot.bat in the Intuit Program folder with Windows Explorer. Make a note of where it is. Now close Explorer, open a command prompt, navigate to the above folder location and run reboot. This is a QuickBooks repair.

QuickBooks needs Power User authority in Windows XP, so check that as well.

Let's start here and let us know. I have been using this feature for years and years and not seen it blocked.

... Thinkpads_User
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
BTW, I am assuming Excel is installed and working on this local machine. ... Thinkpads_User

Author

Commented:
had to reinstall ms office
I managed to fix the issue by installing office 2007 on the 2003 R2 32bit TS server, thanks to thinkpads_user post.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial