Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Excel for Mac Running Very slow

2.4 GHZ intel core 2 Duo, 4GB Ram.


just click on a cell can take 1-3 min


if i need to change anything in a cell it can take any where up to 5 min (eg, changing melbourne to Melbourne)


ever worse if working of a server

MacBook Pro, Mac OS X (10.6.8)

Posted on Jul 18, 2011 7:01 PM

Reply
Question marked as Best reply

Posted on Dec 17, 2012 3:51 AM

Hello All


I was pulling my hair out because of this problem, and was particularly annoyed because the older version of Excel runs fast, but of course it can't open the new .xlsx files. I wanted to upgrade because I also use Excel at work on a PC and I love the ribbon.


I have found the answer and it's pretty obvious when you think about it...


Turn off all the "Microsoft Knows Best" automatic checking that Excel (and Word and Powerpoint) do. Not just the font menu thing, but EVERYTHING in the preferences that does something "automatically".


The only thing I left on automatic was the "autosave" feature.


Now excel runs as fast as it's Windows counterpart.


Chris

89 replies

Jan 13, 2015 6:20 AM in response to torasama

So, I'm not sure that this is right place to ask the question (cry) but... please hear me...


Recently (a month ago) I got MacBook Pro 13" Retina i5 8GB 512GB. And fine. Excellent machine.

Further, all my work is related to Microsoft Office; Outlook, Excel, Word.


So I bought Office365. Installed it and what I got is Office 2011 for Mac. not even close to Office 2013 for Windows (which I was previously using)

And then I bought Parallels. Installed Windows 8 on them and then again used my Office365 licence and installed that office on Windows@Parallels - so now I have MAC with Yosemite with Parallels with Windows 8 and Office365(Win).


And now all of that is SLOW. My PC 5 years old is 5x faster for Office apps.

What to do?

Please advise.

Best regards.

May 3, 2015 6:26 AM in response to chris D'Costa

The font idea was very good. The process I used was a little different. I clicked on a cell to the right of my data on a worksheet in my file, I used Command A to highlight the entire page. I then changed the font name and size and then did it again to get the font and size I wanted for the entire worksheet. I repeated the process for each worksheet in the file. The file then opened in a matter of seconds (still slower than I would like) instead of the 3 minutes it was taking prior to that time. Hope this helps someone else.

Sep 2, 2015 6:08 AM in response to leon21

Hi everyone! I am a newy at Mac, migrated from PC only 2 months back. I own a MacBook Pro 13,3 with Core I5 4 gb and 128 GB SSD. I have Office 2011, and I am having a lot of trouble, speed-regarding, with Excel. I have a big data base, which works perfectly on PC but does not seem to work on Mac. I have already tried the font trick, and didnt work. Any other ideas? Mac is beatiful, but work is not as smooth as I hoped.

Thanks,

Fede

Sep 2, 2015 6:23 AM in response to Fedes CC

Excel on a Mac can be a dog compared to the Windows version - large data sets can drag it down. Since I have several spreadsheets that rely on the Windows macro language (which is very different from the Mac version in its window and GUI handling) I have Windows in BootCamp on my Mac just for Excel (and sadly Access). I generally try to use Windows in Parallels Desktop I actually have found that Excel running on Windows 7 using Parallels Desktop can be faster than the native Mac version.

Excel for Mac Running Very slow

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.