phantom excel window on quickbooks export

When I export from QuickBooks 2014 to a new spreadsheet in Excel 2013, I get two spreadsheets: the one I wanted plus a blank one.  The blank one cannot be closed; it goes away only when I forcibly close Excel with the Task manager.  If I export 6 spreadsheets, I get 6 ghost Excel windows.  I never had the problem with earlier versions of Office.  Anyone know if this is a new "feature"?  Any way to override it?

Roland Garton
Roland GartonPresident / Lead ConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
It is not a feature of QuickBooks to open a file that has to be closed with Task Manager.

Open QuickBooks and a company ledger. Select a report and choose Excel. First look at their options. There is an option to open a help sheet and I unselect (uncheck that). Review the options so that Excel Export only makes one sheet.

I do this with QB 2014 and Excel 2013 without issue.

If you still have an issue, uninstall QuickBooks, do an Office Repair from Control Panel and update Office (updates out yesterday). Restart, Reinstall QB and patch (there are QB updates). Restart again and test.
0
Roland GartonPresident / Lead ConsultantAuthor Commented:
I always turn off that help sheet option...that's not the problem.  I also get a phantom file when opening an Excel spreadsheet from Windows Explorer, I just discovered.  I have other problems with Office2013, so an Office Repair sounds like it's worth trying.  Can you point me to Office Repair tool in the Control Panel?  I don't see any option like that.
0
JohnBusiness Consultant (Owner)Commented:
Go to Control Panel, Programs and Features, find Microsoft Office, click on it, and select Change. From there you can do a repair. Do a full repair.

I would uninstall QB2014 while doing this. It is easy to re-install after you have restarted.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Roland GartonPresident / Lead ConsultantAuthor Commented:
QB install is easy, yes, but time-consuming.  Would it really matter that much?

I tried the full online Microsoft Office Repair option, and it said it could not find the Internet files needed for the repair.  Then nothing, except none of my Office programs were available.  I went through a re-install of Office, and the programs seem to be back, along with phantom Excel spreadsheets when I open from Windows Explorer.  Now it's stuck on "We're wrapping things up" message with orange bar at about 40%, but Office works again.  I'll wait another hour or so and try the repair option again, but the question stands--would it really matter whether QB is installed or not while repairing Microsoft Office?
0
JohnBusiness Consultant (Owner)Commented:
It is probably OK to leave QB installed if it is more convenient to do so.
0
Roland GartonPresident / Lead ConsultantAuthor Commented:
I tried the complete online repair option, and the problem persists.  It's apparently more a Microsoft problem than a QuickBooks problem.  Whenever I open an Excel file by double-clicking on the filename in Windows Explorer, I get the desired Excel window plus the phantom Excel window.  Unlike the QB-created phantoms, though, I can close out of the phantom window.  If I run Excel first, and then open a file from within Excel, the behavior is as expected--no phantoms.  (The phantom window looks just like an Excel window without any Excel files open.)

So, you've helped me clarify some of the conditions under which the problem occurs.  Have anything else to try?  Should I pose the question in a different forum just for Excel weirdnesses?
0
JohnBusiness Consultant (Owner)Commented:
Should I pose the question in a different forum just for Excel weirdness?

This question already has an Excel tag. So if you wish to post a different question, you should close this one first.

Thank you.
0
Roland GartonPresident / Lead ConsultantAuthor Commented:
John, thanks for helping me isolate this problem.  The solution, it turns out, was to remove all files from C:\Users\Owner\AppData\Roaming\Microsoft\Excel.  There were a lot of autosaved files there.  Once I cleaned out that folder, the ghosts disappeared.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JohnBusiness Consultant (Owner)Commented:
I am glad you got it solved and that is great. Normally when we help you to solve a problem (and you said I did), you might offer some assist points in the solution.
0
Roland GartonPresident / Lead ConsultantAuthor Commented:
How do I offer assist points?  I wanted to do that, and asked a moderator how, and got the following response from Customer Retention Specialist Kristina Bulovic: " Unfortunately there is not a way to award just partial points to John."
0
JohnBusiness Consultant (Owner)Commented:
Thanks Roland.  There is a way, but it probably is not really worth at this point. I am glad you got the problem solve and I was happy to see the additional information. So let's just leave it like this now.  Thank you again.
0
Roland GartonPresident / Lead ConsultantAuthor Commented:
I got the solution from Microsoft Users Forum.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.