?
Solved

phantom excel window on quickbooks export

Posted on 2014-08-30
12
Medium Priority
?
893 Views
Last Modified: 2014-09-10
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
0
Comment
Question by:RolandGarton
  • 6
  • 6
12 Comments
 
LVL 99

Expert Comment

by:John Hurst
ID: 40294551
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
 

Author Comment

by:RolandGarton
ID: 40294834
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
 
LVL 99

Expert Comment

by:John Hurst
ID: 40294840
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:RolandGarton
ID: 40295876
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
 
LVL 99

Expert Comment

by:John Hurst
ID: 40295883
It is probably OK to leave QB installed if it is more convenient to do so.
0
 

Author Comment

by:RolandGarton
ID: 40295913
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
 
LVL 99

Expert Comment

by:John Hurst
ID: 40295916
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
 

Accepted Solution

by:
RolandGarton earned 0 total points
ID: 40306222
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
 
LVL 99

Expert Comment

by:John Hurst
ID: 40306239
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
 

Author Comment

by:RolandGarton
ID: 40306399
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
 
LVL 99

Expert Comment

by:John Hurst
ID: 40306468
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
 

Author Closing Comment

by:RolandGarton
ID: 40313989
I got the solution from Microsoft Users Forum.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question