Forum Discussion
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 worksheets, so after some online research, the general advice was that 64 bit versions can work with larger workbooks and access RAM better than the 32 bit.
I purchased and installed the 64 bit of Office Pro Plus 2029.
I open my workbook (this opened fine) and selected a worksheet with 93,000 rows of data across Columns A - I.
I have a Macro that simply clears this sheet so I ran it and Excel just sits there with the message in the title bar saying not responding and in the bottom right there is a flashing text that says "Calculating (8 Threads) 0%".
I left it for 10 minutes before using Task Manager to close Excel down
I rebooted my laptop, opened Excel, manually selected 93,000 rows of data across Columns A - I and pressed the delete key ,and the same thing happens.
This is unuasable and much MUCH worse than the 32 bit.
At least the 32 bit version did not crash and performed all of the functions, albiet slowly.
I have checked the box for 'Disable hardware graphics acceleration'.
Is there anything that I am doing wrong or can do to cure this as I can not keep purchasing different versions of Office to perform a simple task such as Delete when I also have many complicated VBA functions that need to work in this workbook but I have not even tried yet?
Many thanks.
- 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.
4 Replies
- 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?
- 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.- 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.
