Excel for mac limitations vba 64 Bit#

If the file was corrupt I'd expect the data analyst to be experiencing significant issues with the file, but he isn't.

Excel for mac limitations vba 64 Bit#

I've repaired Home Permissions (no improvement) completely uninstalled Office suite and installed 64 Bit versions of the Office suite (no improvement).

I've spent around 6 hours on tech support calls with Apple, Microsoft and Parallels but no progress has been made. The problem persists in each of these environments. I've also tried working with the Excel file using my MacBook Pro (mid-2013 2.5Ghz Core i5 8GB RAM 500GB SSD Mojave) using Excel for Mac and Excel for Windows in Boot Camp. I've tried Excel for Mac, Excel for Windows in Parallels using Windows Virtual Machine, and Excel for Windows in Boot Camp. no calculations being performed.Īs soon as I edit the file in any way, even something simple such as inserting a row in a worksheet, the CPU usage increases to ~775% and the data read rate drops to <1MB/s. My iMac will open the raw data file using Excel for Mac (64 Bit version), however, Activity Monitor shows Excel running the CPU at ~200% even as 'rest', i.e. I have used stress test software and the Fusion Drive appears to be fine : ~230 MB/s write ~450 MB/s read.Īlthough the raw data file is large, the data analyst can open the file and edit it without significant performance issues. My primary computer is my iMac (late 2012 build quad core i7 3.1ghz 1TB Fusion Drive 16GB RAM Catalina). He is using a MacBook Pro which I think is running a dual core i5 and SSD. The first file contains the raw data (several worksheets total file size ~110MB) the second file contains the outputs (tables pivots slicers graphs 10MB total file size) and is linked to the raw data file (the raw data file is the source file). I am collaborating with a data analyst using two linked files stored in a shared folder in my Dropbox.