Forum Discussion
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...
- 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.
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.
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.
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.
I work from home and I simply can not waste days waiting for replies or solutions.
Thanks everyone.