ML
    • Register
    • Login
    • Search
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups

    Weird Excel Issue when closing saved workbook

    IT Discussion
    4
    17
    1341
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • syko24
      syko24 last edited by syko24

      I have an issue with Excel 2016 and was wondering if anyone else has run across this yet. Basically, if I open the program and then close without saving, Excel closes fine. If I save either to the local disk or network and the go to close, in most cases the workbook closes but Excel does not. I can keep clicking on the X and it just won't close. ALT-F4 does not work either. I do not get a "Not Responding" or any other indication that there is a problem. The only way to close is to end task. It will sometimes freeze when I click Browse to open a file as well. Kind of feel like it is Windows Explorer related but I am not having issues in any other programs. MS Word does not have this issue so I'm not really sure what to think at this point.

      Any suggestions???

      Things I've tried:

      1. Quick Repair
      2. Full uninstall reinstall
      3. Disabled all addons and COMs
      4. Uninstalled Intel HD Graphics
      5. Updated MaxxWave Dell sound drivers - apparently there was an issue with OptiPlex 3040's and 3050's
      6. New user profile
      7. Excel Safemode
      8. Check DDE under options and then uncheck
      9. Disable Graphics Acceleration under options
      10. Disabled Antivirus
      11. Installed latest Windows Updates and Office Updates
      12. Rolled back updates to different builds of Office
      jmoore 1 Reply Last reply Reply Quote 1
      • Dashrender
        Dashrender last edited by

        Try running a chkdsk /r or Spinrite on the local drive.

        It's possible there's a problem with the disk where the temp file is being written, and Excel is having a hard time cleaning it.

        syko24 1 Reply Last reply Reply Quote 0
        • jmoore
          jmoore @syko24 last edited by

          @syko24 another thing I have seen that could be related is if your disk is maxing out. I have seen some of our slow disks do this and cause weird issues

          syko24 1 Reply Last reply Reply Quote 0
          • syko24
            syko24 @Dashrender last edited by

            @dashrender - Thanks for the suggestion. I'll try that one tonight.

            1 Reply Last reply Reply Quote 0
            • syko24
              syko24 @jmoore last edited by

              @jmoore - no definitely have plenty of space on the disk.

              jmoore 1 Reply Last reply Reply Quote 0
              • syko24
                syko24 last edited by

                Another thought was if there was a Windows Update that messed something up.

                1 Reply Last reply Reply Quote 0
                • black3dynamite
                  black3dynamite last edited by

                  Is this happening on Windows 10 1709?

                  syko24 1 Reply Last reply Reply Quote 0
                  • syko24
                    syko24 @black3dynamite last edited by

                    @black3dynamite said in Weird Excel Issue when closing saved workbook:

                    Is this happening on Windows 10 1709?

                    No running Windows 10 Pro 1703 (10.0.15063)

                    1 Reply Last reply Reply Quote 0
                    • syko24
                      syko24 last edited by

                      Running chkdsk /r remotely. Waiting patiently for it to come back up holding breath.

                      Dashrender 1 Reply Last reply Reply Quote 1
                      • Dashrender
                        Dashrender @syko24 last edited by

                        @syko24 said in Weird Excel Issue when closing saved workbook:

                        Running chkdsk /r remotely. Waiting patiently for it to come back up holding breath.

                        did it finish?

                        syko24 1 Reply Last reply Reply Quote 0
                        • syko24
                          syko24 @Dashrender last edited by

                          @dashrender said in Weird Excel Issue when closing saved workbook:

                          @syko24 said in Weird Excel Issue when closing saved workbook:

                          Running chkdsk /r remotely. Waiting patiently for it to come back up holding breath.

                          did it finish?

                          Yeah still a no go. It's just weird because if I click the x nothing happens. I just get the circling curser. I can still click File and Close and the document closes fine but I can't exit out of Excel without an end task.

                          1 Reply Last reply Reply Quote 0
                          • syko24
                            syko24 last edited by

                            Kind of feel like I need to nuke and do a system reinstall. Just don't want to reinstall everything just to be right back where I'm at afterwards.

                            1 Reply Last reply Reply Quote 0
                            • black3dynamite
                              black3dynamite last edited by

                              Have you already tried booting into safe mode too?

                              syko24 1 Reply Last reply Reply Quote 0
                              • syko24
                                syko24 @black3dynamite last edited by

                                @black3dynamite said in Weird Excel Issue when closing saved workbook:

                                Have you already tried booting into safe mode too?

                                Yes, windows safe mode as well as excel safe mode.

                                1 Reply Last reply Reply Quote 0
                                • black3dynamite
                                  black3dynamite last edited by

                                  Have you already tried updated the drivers for storage?

                                  1 Reply Last reply Reply Quote 0
                                  • jmoore
                                    jmoore @syko24 last edited by

                                    @syko24 said in Weird Excel Issue when closing saved workbook:

                                    @jmoore - no definitely have plenty of space on the disk.

                                    sorry i wasn't clear. i meant disk reading/writing. if your disk is doing too much too fast then that can cause weird issues

                                    1 Reply Last reply Reply Quote 0
                                    • syko24
                                      syko24 last edited by

                                      So I believe I was able to resolve the issue. I ended up rolling back my Office updates using the method from https://support.microsoft.com/en-us/help/2770432/how-to-revert-to-an-earlier-version-of-office-2013-or-office-2016-clic . I had tried numerous versions but none seemed to work. I ended up trying Build 1707 16.0.8326.2073 and holy crap it worked.

                                      Just another observation before I had rolled back is that Excel was using a high amount of CPU (about 45% to 50%). I have seen other people complain about CPU being high in some older versions but it was typically related to the Creators Update and not Office updates.

                                      Anyways, thanks for all the suggestions!! I will let you guys know if this one blows up on me too.

                                      1 Reply Last reply Reply Quote 3
                                      • First post
                                        Last post