Frequent spinning ball when using Excel

[mahera]

Whenever I use Excel and input a format, the rainbow wheel comes up for a few seconds and the window freezes.

I've restarted my Mac several times, re-installed Excel, and even deleted the application and installed through the App Store

 

[circatee]

Does this happen on NEWLY created Excel documents, or mainly existing Excel documents?
On my MBP, I have 32GB memory. And, when I first open Excel, I see the beach ball for about 3 seconds, and not again...

 

[mahera]

It's happening in both New and existing documents. The document does have a lot of data in it, but I have had no problems with previous macs or on a different laptop

I have an M1 Pro MBP with 16GB of memory

 

[circatee]

So, when you initially open Excel (Quit it, wait a couple seconds and launch it), it does the same?

 

[mahera]

Same thing happening, I'm not sure if it's because the amount of data in it, but it shouldn't be constantly freezing as far as I'm aware. I know several other people had problems online but I couldn't find a solution.


Also on the latest version of Monterey

 

[circatee]

Same thing happening, I'm not sure if it's because the amount of data in it, but it shouldn't be constantly freezing as far as I'm aware. I know several other people had problems online but I couldn't find a solution.


Also on the latest version of Monterey

What I find odd, is that when you open the Excel application (NOT AN EXCEL document), to me, it shouldn't beach ball, but for a few seconds, if that.

So, to make sure am clear, when you're opening the application, you are opening JUST Excel and not an Excel document, and the same thing happens?

 

[theorist9]

I have this too, including with small (<20 KB), newly-created Excel files. I routinely get the spinning beachball with simple operations, like selecting a cell, even if the cell is values-only (no formulas). I've experienced this for years, on a variety of Macs, with a variety of Excel versions. I've never experienced this when using Excel on a PC.

I'm using the latest versions of Monterey (12.6.4) and Excel (16.71) as of the date of this post, on a 2019 i9 iMac with 128 GB RAM.

Running it in a RAM disk seems to reduce the duration of the spinning beachballs somewhat, but doesn't make them go away.

 

[StoneJack]

delete excel preferences.
open a new user and try app from there.