Financial Software

Financial Software Questions? Ask IT Support for Answers ASAP

Ask an Expert,
Get an Answer ASAP!

Financial Software
This answer was rated:

Excel can not open the data file when I export a report to

Excel can not open the...
Excel can not open the data file when I export a Quickbooks Premier report to Excel. I'm using Quickbooks Premier 2011 and Excel 2007. I have contacted Intuit and they walked me through uninstalling and reinstalling Quickbooks. They said that it was a Microsoft problem. Contacted Microsoft and they said that it is a Quickbooks problem. Nevertheless, I still can't export a Quickbooks report to Excel ever since I upgraded to Quickbooks Premier 2011. I was able to export reports to Excel in the 2010 version.
Show More
Show Less
Ask Your Own Financial Software Question
Answered in 8 hours by:
3/29/2011
Doug Millington
Doug Millington, Certified Public Accountant (CPA)
Category: Financial Software
Satisfied Customers: 268
Experience: Bachelor of Science Cornell University 1979 - CPA since 1981 - Certified QuickBooks ProAdvisor - 30+ years experience.
Verified

Doug Millington :

If you have a question about accounting, bookkeeping, QuickBooks or Peachtree I have the answer.

Doug Millington :

OK - what is the exact message you receive from QuickBooks when you go to export to Excel?

Doug Millington :

Also to try to pinpoint the problem please try the following:

Doug Millington :

(1) Run any standard report and click the Export button - then select the radio button "a comma separated values (csv) file" and try to export

Doug Millington :

(2) Follow the same steps in one except choose to export to an "existing excel report" radio button - and choose any exisiting

Doug Millington :

Excel file to export the report

Doug Millington :

Please let me know what happens when you try these two variations on exporting to Excel + the exact error message you are receiving from QuickBooks when you try to export to a new Excel file.

Customer:

Exact message - "Excel could not open the data file".

Customer:

1) csv file will export. File will open in Excel. It contains the data in the proper columns but is not formatted with underlines, headings, etc.

Customer:

2) I exported the report to an existing file. The file wanted me to open it as a read only file. It did add the spreadsheet to the existing file. Now every time I want to open the existing file, Excel says that the file is already open but I don't have Excel open.

Doug Millington :

OK - one moment

Doug Millington :

OK - let's repair the Excel installation - what operating system is on your computer?

Customer:

Windows Vista

Doug Millington :

OK - (1) Click the Windows Start button and select Control Panel.
(2) In the Control Panel, click on Programs.
(3) In Programs, click on Programs and Features.
(4) In Program and Features, select Microsoft Office.
(5) Once Microsoft Office is selected, click Change.
(6) In the Microsoft Office Installation window, select the Repair radio button, click Next, click Repair.
(7) Click Finish. Your installation of Microsoft Office should now be repaired

Customer:

It is asking me "Are you sure you want to remove Microsoft Professional 2007 from your machine?"

Doug Millington :

NO DO NOT REMOVE

Doug Millington :

You are looking for a Repair radio button

Customer:

I see now the change button. I clicked on it and it says please wait while Setup prepares the necessary files and then the window goes away.

Doug Millington :

Make sure you select "Change"

Doug Millington :

Oh - that's not good

Doug Millington :

Do you have the CD for MS Office?

Customer:

Yes

Doug Millington :

I know this will sound a little radical but I would suggest uninstalling and then reinstalling MS Office - the down side is that you will have to go to Windows Update and download any of the updates after you reinstall which takes some time but I do think the issue is with Excel and not QuickBooks especially since you can export a csv file successfully

Customer:

How long do you think it will take? Is this something that I need to alot some time tomorrow to do?

Doug Millington :

I would estimate about an hour to a hour and a half - the problem with the updates is that you have to keep checking after each update to see if any more updates are available

Doug Millington :

plus you have to reboot al ot

Customer:

Sounds like a tomorrow project. Do I come back to this chat to let you know how things turned out after I uninstall and reinstall?

Doug Millington :

yes

Doug Millington :

I do have a very busy day tomorrow and will not be available till after 6pm

Doug Millington :

We can work in this char window till you are up and running with the export to Excel feature

Customer:

No problem. I'll leave you a message. I uninstall through Control Panel and then insert the CDs and reinstall the software. Correct?

Doug Millington :

yes - reboot after you uninstall

Doug Millington :

then reinstall

Doug Millington :

then download any updates

Customer:

Where do I go to get the updates?

Doug Millington :

you go to either Microsoft Updates or Windows Updates

Doug Millington :

It should be a choice when you click on Start and then prpgrams

Customer:

Do these normally download automatically on a routine basis or should I be going to these sites looking for available downloads?

Doug Millington :

they normally download as they are released but since you are going to reinstall from the original CD you should go and seek them out

Doug Millington :

you can also do a google for Windows Updates

Customer:

Thanks.

Doug Millington :

OK - we'll chat tomorrow - hopefully this will do the trick

Customer:

OK

Doug Millington :

great

Customer:

Been busy the last 2 nights. Just now trying to uninstall and reinstall Microsoft Office 2007. Tried to uninstall through Control Panel. Got error message "Microsoft Office Professional 2007 uninstall did not complete successfully".

Doug Millington :

OK - check out this support article from Microsoft on how to manuallu uninstall MS Office - http://support.microsoft.com/kb/928218

Doug Millington :

There are a bunch of steps involved - just take your time and read through the instructions a couple of times to gain a clear understanding of what they want you to do

Doug Millington :

I will be available all day except for an errand or two I have to run - let me know what happens.

Customer:

Thank you.

Doug Millington :

OK - let me know how it goes and if you run into any problems.

Customer:

WORKS!!! It was a pain uninstalling Excel but the uninstall finally worked. Reloaded Office 2007 and now I can export Quickbooks 2011 reports to Excel.

Doug Millington :

Outstanding!!

Doug Millington :

It's not always QuickBooks but the software it interacts with

Doug Millington :

any more questions?

Customer:

How much do I owe you for your time?

Doug Millington :

If you feel I did a good job you can add a bonus payment to the answer after you click accept and postive feedback is always welcome.

Customer:

I'll do both!!!

Doug Millington :

Thanks - enjoy the weekend - you're off to a good start

Customer:

Thank you. You too.

Doug Millington
Doug Millington, Certified Public Accountant (CPA)
Category: Financial Software
Satisfied Customers: 268
Experience: Bachelor of Science Cornell University 1979 - CPA since 1981 - Certified QuickBooks ProAdvisor - 30+ years experience.
Verified
Doug Millington and 87 other Financial Software Specialists are ready to help you
Ask your own question now
Ask Doug Millington Your Own Question
Doug Millington
Doug Millington
Doug Millington, Certified Public Accountant (CPA)
Category: Financial Software
Satisfied Customers: 268
268 Satisfied Customers
Experience: Bachelor of Science Cornell University 1979 - CPA since 1981 - Certified QuickBooks ProAdvisor - 30+ years experience.

Doug Millington is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response...

T.G.WMatteson, IL

I WON!!! I just wanted you to know that your original answer gave me the courage and confidence to go into yesterday's audit ready to fight.

BonnieChesnee, SC

Great service. Answered my complex tax question in detail and provided a lot of additional useful information for my specific situation.

JohnMinneapolis, MN

Excellent information, very quick reply. The experts really take the time to address your questions, it is well worth the fee, for the peace of mind they can provide you with.

OrvilleHesperia, California

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

< Previous | Next >

Meet the Experts:

Robert M.

Robert M.

Consultant

3,077 satisfied customers

30 yrs. of computer experience in financial and marketing departments.

Doug Millington

Doug Millington

Certified Public Accountant (CPA)

268 satisfied customers

Bachelor of Science Cornell University 1979 - CPA since 1981 - Certified QuickBooks ProAdvisor - 30+ years experience.

AnswerCPA

AnswerCPA

Advisor

175 satisfied customers

QuickBooks Pro Advisor

Leanne Stewart

Leanne Stewart

Quickbooks Pro Certified

153 satisfied customers

QuickBooks certified, in my own business for 7+ years.

David Bennett

David Bennett

Certified QuickBooks ProAdvisor

91 satisfied customers

16+ yrs exper. QuickBooks Specialist, contract accounting technician, consultant & trainer!

jgordosea

jgordosea

Enrolled Agent

80 satisfied customers

Three years as Expert support for Turbotax Ask a Tax Expert, Quickbooks support and use >6 yrs

Tom K

Tom K

Assistant Information Systems Manager

47 satisfied customers

Experienced in the usage of Financial programs such as Quickbooks, Peachtree, and Quicken.

< Previous | Next >

Related Financial Software Questions
I just purchased Quicken Home, Business and Rental Property.
I just purchased Quicken Home, Business and Rental Property. I have tried 3 times to install it using Quicken I stall Wizard. Each time it installs about 1/4 if the way - stops- and eventually a new w… read more
Kris R
Kris R
IT Manager
Computing
2,652 satisfied customers
On Quicken, my Fidelity transactions will not download.
On Quicken, my Fidelity transactions will not download. Fidelity ran a test file which downloaded the transactions just fine. Quicken tech and Fidelity tech both say there is corruption in the Quicken… read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
How do I download Turbo Tax on my MacBook Pro? Newest
Newest version. Just purchased last fall. No insert for cd … read more
Mr.Med
Mr.Med
943 satisfied customers
When I open my computer or Qw a menu pops up and wants me to
When I open my computer or Qw a menu pops up and wants me to down load a new update. This has been going on for months. I have worked through finding my passwords, Quicken ID, and got what I thought w… read more
technicalcat
technicalcat
Computer Science
838 satisfied customers
My hard drive was corruppted and I need to download Quicken
my hard drive was corruppted and I need to download Quicken 2018 again … read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
My Quicken Account is all screwed up. I have Quicken 2016
I have Quicken 2016 that I am happy with and apparently I need an upgrade to continue using this program. What am I supposed to do? I tried to purchase an upgrade and the amount kept doubling and my credit card was not accepted. … read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
I downloaded a return from 2016 onto my 2017 software and in
I downloaded a return from 2016 onto my 2017 software and in listing expenses on schedule "C" I cannot delete data from the carryforward of 2016. Please advise how I can delete the 2016 data I broth f… read more
cvd4311
cvd4311
Computer Analyst
Bachelor\u0027s Degree
717 satisfied customers
I tried to set up a new account "Home 2018." Quicken lost my
I tried to set up a new account "Home 2018." Quicken lost my "Home 2017" and "Home 2016" accounts, and an account from 2017 "PC". It kept 2015 back through 2009. I need to re-access these 2017 account… read more
Kris R
Kris R
IT Manager
Computing
2,652 satisfied customers
How can I delete a duplicate customer payment when the
How can I delete a duplicate customer payment when the deposit shows the amount only 1 time? … read more
Emilee Weaver
Emilee Weaver
Controller
Masters of Professional Accounting
73 satisfied customers
Do I need to remove my quicken program and reinstall it when
Hi: do I need to remove my quicken program and reinstall it when I have had problems with my router? The printer indicates it is connected to the computer, so it's not a printer problem. … read more
Jinsmn
Jinsmn
Systems Administrator
Diplom
1,260 satisfied customers
Resident in Australia, registered with Companies in Intuit
Resident in Australia, registered with Companies in Intuit Aus. Now want to be linked into a Co. in Bermuda using QB's USA … read more
Josh
Josh
It Support Specialist
Associate Degree
5,140 satisfied customers
I would like to cancel my upgrade for 2018. How? I tried
I tried many times to add 2018 to my existing account. Can't do it!! … read more
Kris R
Kris R
IT Manager
Computing
2,652 satisfied customers
I updated to windows 10 and updated to 2018 quicken but I
I updated to windows 10 and updated to 2018 quicken but I can't access my quicken files. … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,281 satisfied customers
I bought a new computer and geek squad transfer my data. As
I bought a new computer and geek squad transfer my data. As a result of this catastrophe I cannot longer get quicken 15 to show my data Is there anyone from your side but I can help … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,281 satisfied customers
I have been using Quicken 2007, 16.2.4 for mac. I am using
I have been using Quicken 2007, 16.2.4 for mac. I am using Mac Sierra 10.13.1. All of a sudden every time I close Quicken it says "Quicken was not able to automatically backup your file". … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,281 satisfied customers
I'm sure that this will be the first of myriad of questions
Please help! I'm sure that this will be the first of myriad of questions that I have about Quicken 18 as I'm not very computer literate.. I was recently forced to upgrade from elegant, intuitive Quick… read more
Kris R
Kris R
IT Manager
Computing
2,652 satisfied customers
I am a user of Quicken since 2007 and am having a problem
I am a user of Quicken since 2007 and am having a problem with the software. I keep getting error messages on a daily basis which momentarily causes me to exit the software and reenter almost on a dai… read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
I am a time tax act user. Today I tried to look at my return
I am a long time tax act user. Today I tried to look at my return but was ouable. It would appear that your software is not on my computer and I cannot do the things I have used over the past few year… read more
Josh
Josh
It Support Specialist
Associate Degree
5,140 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x