Help with Excel on a Mac

Bedford

Board Regular
Joined
Feb 3, 2015
Messages
94
I work on a mac, I created a workbook that suited my needs with the help of a number of MrExcel members, I thank all of you. When the workbook was created I was using Excel, Office 2011, 6 months ago, upgraded to Excel, Office 365.
Since upgrade, the workbook is very sluggish, and acts erratically, the mac I use is;
Macbook Pro
OS 10.14
Intel Core i7
2.8 GHz
1 Processor, 4 core
L2 Cache (per Core): 256 KB
L3 Cache: 6 MB
Memory: 16 GB
HD-1tb

I have had numerous calls with MS, last 3 calls with Level 3 tech, no help. I have recreated the workbook in native Excel 2016, and it remains sluggish and jumpy.
Any suggestions how I can get help with this?
Thank you,
Doug.
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

cooper645

Well-known Member
Joined
Nov 16, 2013
Messages
543
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
  4. Web
What erratic behaviour are you getting?

What file type type is it?

what is slowing down exactly? (If you can pinpoint something; calculating, movement on screen, generally the MacBook etc)
 

Bedford

Board Regular
Joined
Feb 3, 2015
Messages
94
It's not anything special in terms of a file type, .xlsx. I've tried pinpointing to no avail.

Interesting enough, I reinstalled Excel 14.7.7 and its working fine, I've seen many who have compatibility issues with mac using 2016.
Thanks for weighting in.


What erratic behaviour are you getting?

What file type type is it?

what is slowing down exactly? (If you can pinpoint something; calculating, movement on screen, generally the MacBook etc)
 

cooper645

Well-known Member
Joined
Nov 16, 2013
Messages
543
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
  4. Web
No problem. I have converted some slow files to xlsb and they are a fair amount faster. Apparently more prone to corrupting but I haven’t suffered yet with that. I keep a back up regularly just in case.

The other thing could could be if you have a growing number of volotile functions this will cause a slow down. I need to start re working some of mine as one contains 8000 NOW() functions and grows by 3000 rows per annum minimum.

if you do pinpoint anything I’ll remain subscribed so as to receive the notification.

Good luck
 

Watch MrExcel Video

Forum statistics

Threads
1,108,585
Messages
5,523,728
Members
409,532
Latest member
Lmfacc

This Week's Hot Topics

Top