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

    Excel freezing

    IT Discussion
    ms office excel
    14
    34
    699
    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.
    • warren.stanley
      warren.stanley @Dashrender last edited by warren.stanley

      @Dashrender What version of Excel? Disabling Excel Graphics Hardware Acceleration on Excel 2013 through to 2019, can resolve display, stability and performance issues. (edited this for terrible grammar!)

      jt1001001 1 Reply Last reply Reply Quote 0
      • scottalanmiller
        scottalanmiller last edited by

        What version of Excel?

        1 Reply Last reply Reply Quote 0
        • jt1001001
          jt1001001 @warren.stanley last edited by

          Second on the hardware acceleration disabling, fixed some weird Word and Excel display issues we had

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

            Office 2016.... OK I'll disable that tomorrow.

            Thanks!

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

              Any luck/update?

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

                The change was made to Excel this morning - but the user has been working other tasks since then... so no - no update.

                That said - over the past week, the user has been informing me of many issues, so if they continue, I should hear about it quickly.

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

                  @Dashrender Make sure your using the 64 bit version instead of the 32 bit. They had me installing the 32 bit version here when I first started and I saw issues like what your describing.

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

                    @jmoore said in Excel freezing:

                    @Dashrender Make sure your using the 64 bit version instead of the 32 bit. They had me installing the 32 bit version here when I first started and I saw issues like what your describing.

                    I switched to installing the 64 Bit version about 6 months ago.

                    This user's computer is about 3 months old, so they should be on 64 bit... but I'll double check.

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

                      Excel... check the specific spreadsheet(s) workbook(s) that they're having problems with.... we've had a few cases where people are causing problems with data references and other wonderful things that they find when googling for a solution. Like statically referencing another file on their desktop or personal share and then sending the file to someone else only to find that it doesn't work for the other person.

                      wrx7m 1 Reply Last reply Reply Quote 0
                      • travisdh1
                        travisdh1 last edited by

                        This is more than a little random, but I've had drivers for HP printers cause issues with Excel after the computer was updated to W10 1903 this week. Fix is simple, remove the PCL6 driver and install the universal print driver.

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

                          Microsoft only recently changed the "recommended" install to 64-bit.

                          Hardware acceleration has given me heartache in the past.

                          Disable add-ins, then enable one by one to see which one causes a hang (if any are causing that).

                          Run a memtest, I've (rarely) had this cause the issue but sometimes a bad stick from the factory has caused Excel-heavy users to experience performance issues.

                          On older PCs, it's sometimes due to a failing drive; but it's unlikely the SSD from the factory is the issue. Just worth noting.

                          Beyond that, it's often content based... pulling tons of links from the network, updating various content on the network that's using cells in the sheets, etc.

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

                            @bbigford said in Excel freezing:

                            Microsoft only recently changed the "recommended" install to 64-bit.

                            Hardware acceleration has given me heartache in the past.

                            Disable add-ins, then enable one by one to see which one causes a hang (if any are causing that).

                            Run a memtest, I've (rarely) had this cause the issue but sometimes a bad stick from the factory has caused Excel-heavy users to experience performance issues.

                            On older PCs, it's sometimes due to a failing drive; but it's unlikely the SSD from the factory is the issue. Just worth noting.

                            Beyond that, it's often content based... pulling tons of links from the network, updating various content on the network that's using cells in the sheets, etc.

                            Decent list of options

                            1. user is on 64 bit - I made the switch for my images about the time MS made the recommendation change
                            2. hardware acceleration is disabled, but only after reported issues
                            3. there are zero Office add-ons
                            4. good idea - I'll run a memtest tonight. This is a 6 month old workstation class HP machine, though it does not have ECC RAM.
                            5. could be failing drive - but this user has been having issues for years over 4+ different machines, seems unlikely.
                            6. The files do all live on the network - a Windows 2012 R2 server. Most if not all of the excel files do not reference other worksheets.
                            bbigford 1 Reply Last reply Reply Quote 0
                            • bbigford
                              bbigford @Dashrender last edited by

                              @Dashrender said in Excel freezing:

                              @bbigford said in Excel freezing:

                              Microsoft only recently changed the "recommended" install to 64-bit.

                              Hardware acceleration has given me heartache in the past.

                              Disable add-ins, then enable one by one to see which one causes a hang (if any are causing that).

                              Run a memtest, I've (rarely) had this cause the issue but sometimes a bad stick from the factory has caused Excel-heavy users to experience performance issues.

                              On older PCs, it's sometimes due to a failing drive; but it's unlikely the SSD from the factory is the issue. Just worth noting.

                              Beyond that, it's often content based... pulling tons of links from the network, updating various content on the network that's using cells in the sheets, etc.

                              Decent list of options

                              1. user is on 64 bit - I made the switch for my images about the time MS made the recommendation change
                              2. hardware acceleration is disabled, but only after reported issues
                              3. there are zero Office add-ons
                              4. good idea - I'll run a memtest tonight. This is a 6 month old workstation class HP machine, though it does not have ECC RAM.
                              5. could be failing drive - but this user has been having issues for years over 4+ different machines, seems unlikely.
                              6. The files do all live on the network - a Windows 2012 R2 server. Most if not all of the excel files do not reference other worksheets.

                              Ah, you'll waste your time on memtest. I didn't realize it was happening on 4 different workstations. It's not the workstation.

                              I've also had this be a permissions issue. I had one weird incident where a file had share and NTFS permissions all over the place. It was basically recalculating the perms while they worked, because I changed shared to FC everyone and gave the person most access to the folder and the issue went away.

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

                                @bbigford said in Excel freezing:

                                @Dashrender said in Excel freezing:

                                @bbigford said in Excel freezing:

                                Microsoft only recently changed the "recommended" install to 64-bit.

                                Hardware acceleration has given me heartache in the past.

                                Disable add-ins, then enable one by one to see which one causes a hang (if any are causing that).

                                Run a memtest, I've (rarely) had this cause the issue but sometimes a bad stick from the factory has caused Excel-heavy users to experience performance issues.

                                On older PCs, it's sometimes due to a failing drive; but it's unlikely the SSD from the factory is the issue. Just worth noting.

                                Beyond that, it's often content based... pulling tons of links from the network, updating various content on the network that's using cells in the sheets, etc.

                                Decent list of options

                                1. user is on 64 bit - I made the switch for my images about the time MS made the recommendation change
                                2. hardware acceleration is disabled, but only after reported issues
                                3. there are zero Office add-ons
                                4. good idea - I'll run a memtest tonight. This is a 6 month old workstation class HP machine, though it does not have ECC RAM.
                                5. could be failing drive - but this user has been having issues for years over 4+ different machines, seems unlikely.
                                6. The files do all live on the network - a Windows 2012 R2 server. Most if not all of the excel files do not reference other worksheets.

                                Ah, you'll waste your time on memtest. I didn't realize it was happening on 4 different workstations. It's not the workstation.

                                I've also had this be a permissions issue. I had one weird incident where a file had share and NTFS permissions all over the place. It was basically recalculating the perms while they worked, because I changed shared to FC everyone and gave the person most access to the folder and the issue went away.

                                Most of these xls files are in the user's Document directory, no permissions have been changed.

                                1 Reply Last reply Reply Quote 0
                                • S
                                  scotth last edited by

                                  Another thing to check is the printer settings on the affected workstation. I've seen the SNMP settings, even though they are correct, needed to be disabled. Blips in the network have caused those connections trying to be re-established and cause frustrating pauses. Clicking on anything in Excel causes it to freeze and crash, but not always.

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

                                    @scotth said in Excel freezing:

                                    Another thing to check is the printer settings on the affected workstation. I've seen the SNMP settings, even though they are correct, needed to be disabled. Blips in the network have caused those connections trying to be re-established and cause frustrating pauses. Clicking on anything in Excel causes it to freeze and crash, but not always.

                                    Interesting - I'll give that a try!

                                    Thanks

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

                                      @Dashrender said in Excel freezing:

                                      @scotth said in Excel freezing:

                                      Another thing to check is the printer settings on the affected workstation. I've seen the SNMP settings, even though they are correct, needed to be disabled. Blips in the network have caused those connections trying to be re-established and cause frustrating pauses. Clicking on anything in Excel causes it to freeze and crash, but not always.

                                      Interesting - I'll give that a try!

                                      Thanks

                                      I've also seen a problem that if their default printer is unavailable for any reason, this will cause it to freeze a lot.

                                      Set the default printer to Microsoft PDF or what-not, and the problem goes away -- the down side is that they have to choose the printer anytime they actually do want to print.

                                      1 Reply Last reply Reply Quote 2
                                      • Dashrender
                                        Dashrender last edited by

                                        So the ongoing saga that is this user.

                                        This morning - the PC had been up for 4 days (which really shouldn't be an issue) when using Excel - sheets were left open over the weekend for sure! - the search function on the open screen would not allow them to click into the search box. It just sat there dumb... you could close it, but nothing else. When you clicked, literally nothing happened.

                                        Rebooting 'fixed' the issue.

                                        The computer has 16 GB RAM and 256 GB NMVe SSD.

                                        notverypunny 1 Reply Last reply Reply Quote 0
                                        • Kelly
                                          Kelly last edited by

                                          Is this a local install or a Click-to-Run version? Might there be something odd going on with OneDrive integration (assuming O365).

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

                                            @Kelly said in Excel freezing:

                                            Is this a local install or a Click-to-Run version? Might there be something odd going on with OneDrive integration (assuming O365).

                                            Local install - We don't have O365. The user does not have OneDrive or OneDrive4Business setup. Nor any other syncing solutions besides the built in Windows sync with the server (Off-line files). But that was disabled last week as part of this troubleshooting as well.

                                            The user hasn't been able to dedicate a large amount of time (well, at least their normal amount of Excel time) to their computer since Friday - so short of the "broken search" ability within Excel yesterday, there have been no reports of issue.

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