Forum Discussion

Kenneth Green's avatar
Kenneth Green
Brass Contributor
Apr 25, 2024
Solved

Changed from Excel Pro Plus 2019 32 bit to 64 bit & now Excel freezes when processing large sheets?

Windows 10 (64 bit) i7-1165Gz 20GB Ram Excel Prop Plus 2019 64 bit   I had Office Professional Plus 2019 32 bit installed and I noticed that Excel was taking a bit to long to process large works...
excel
Macros and VBA
  • Kenneth Green's avatar
    Kenneth Green
    Apr 25, 2024
    No further replies are needed as I have gone back to 32 bit Office.

    I work from home and I simply can not waste days waiting for replies or solutions.

    Thanks everyone.
JKPieterse's avatar
JKPieterse
Silver Contributor
Apr 25, 2024
If you just open the workbook and press Control+Shift+Alt+F9, does it also take ages to calculate? If yes, the actual problem probably is that your workbook is quite calculation intensive. Does the workbook use VBA User Defined Functions?
  • Kenneth Green's avatar
    Kenneth Green
    Brass Contributor
    Apr 25, 2024
    Hi Jan.

    I pressed Control+Shift+Alt+F9 and allowed it to run for 12 minutes then Excel stopped responding so I had to shut it down in the task manager.

    Interestingly, I had task manager open so I could see what was going on CPU and memory wise while Excel was running Control+Shift+Alt+F9 and it shows only 22% CPU & 38% Memory.

    The performance tab shows only 22% CPU Utilization, the memory Tab shows 7.3 GB oin use and 12.2 GB Available.

    This is terrible CPU and RAM usuage.

    I do not have and VBA User Defined Functions but I do have some VBA Subs that I can call on to perform tasks but they do not run automaticly, I have to run them.

    In the 32bit Office, those subs ran with out issue, The subs are simple, they add or remove cell formatting, one pulls data from one sheet to another, and another sorts the data but as I said, they have to be ran by me.

    I do not understand why the 64 bit version of office, when ran on a 64 bit OS is behaving so poorly.
    • Kenneth Green's avatar
      Kenneth Green
      Brass Contributor
      Apr 25, 2024
      No further replies are needed as I have gone back to 32 bit Office.

      I work from home and I simply can not waste days waiting for replies or solutions.

      Thanks everyone.
      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Apr 26, 2024

        Kenneth Green I understand your sentiments. Please know that most people responding here are volunteers, this is not a place frequently monitored by Microsoft staff.

        Given that your workbook takes (at least) more than 12 minutes to recalculate I must conclude that is the real issue. I expected the bitness of Office not to have too much effect on the calculation performance. I am surprised that you are facing issues you did not have with the 32 bit version.

         

        Not of any help, but as far as I know, your "old" office license should have entitled you to install either the 32 or the 64 bit version with no extra cost. But I am no licensing expert 🙂

         

        I am happy to take a look at your file (for free), you can reach me through the email address at the bottom of my website https://jkp-ads.com 

Resources