Excel documents won't close

Silly and simple but extremely annoying problem: I'm using a macro activated excel workbook, and this doc is open on my laptop most of the day. Problem is when this doc is open I'm not able to close other open Excel files. The only way to close a excel doc is to close the macro activated excel doc first. Another issue (not that annoying); when opening a new excel doc it opens ok but doesn't always pop up on the screen, have to ALT+TAB to the newly opened doc.

I've tried repairing Office 2013, and tried uninstalling/reinstalling with no luck. The doc is in xls-format (compatibility mode). Even tried creating a new macro activated doc/xlsm-format, same problem. Also tried experimenting with DDE settings (turning on "ignore other programs using DDE") with no luck. Opened the same docs on another laptop, works fine, so problem is local.

Using Office 2013, all updates installed. OS: Win10 Pro (had same issue using Win 8.1).

Any ideas how to solve this?
Roar GaulenAsked:
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.

ProfessorJimJamCommented:
please see my answer to similar question that was accepted.

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28686150.html

I would say the script is causing the whole issue that means that script ending code does not actually quit the application.

it would be difficult to identify the problem without seeing the script.

perhaps the script is using the below method

Dim ExcelApp As Object
Set ExcelApp = CreateObject("Excel.Application")

Open in new window

                                         

which at the end of the code after  Workbook.Close SaveChanges:=False you need to put back
     
  ExcelApp.Quit
        Set ExcelApp = Nothing

Open in new window

                                         


in order to quit the application.

so unless the script is fixed, now matter how many time you freshly install Microsoft, the script will spoil the open instance of Excel
0
Roar GaulenAuthor Commented:
Thanks for your reply. The problem isn't in the code. To verify I closed all open workbooks, created a new empty one (xlsx), opened Visual Basic editing windows and just hit Save (with no code at all), then closed the document and reopened it. The new test document has the same issues as the original one, when open I can't close other  open excel docs.
0
Roar GaulenAuthor Commented:
I've found a workaround, running excel.exe with the /x switch to start a new Excel instance, then open each doc from within Excel. Not ideal but maybe I can live with it.. Would be even better to set up Excel to automatically open each doc in new instance, I know this is not recommended but I think as long as my docs don't interact with each other it's not a problem. Anyone know how to set this up (always run with the /x switch)?
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
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
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.