Excel 2019 Processing Slow in large workbooks

Copper Contributor

Hi,

 

I use excel on a daily basis for work. The excel files I work in are around 7 MB in size and contain links/formulas/macros throughout. Whenever I input manually input data, excel will freeze for 30 seconds. But if I copy and paste from a separate workbook, it operates fine. It only hangs up when I input data in the the workbook.  I have turned off auto-calculate, and saved files down to my desktop, but that has not helped. My other co-workers do not have this same issue, and their machines have slower processing speeds. I use Excel 2019. Anyone come across issues like this using office 19?

 

The computer I use has an intel i5 cpu (4 core 8 processor) with 32GB of ram. I don't think the specs are the issue.

0 Replies