Excel performance in Windows vs Apple Mac
Hi,
I have an Excel application which works fine in Windows (7) and Excel 2010 but perform utterly badly in an Apple Mac with the ordinary office package.
The background:
The application consists of a summary sheet with 13000 cells that contains Formulas. In 1/3 of it is simple formula like =RC + R[3]C[-7] or =sum, the rest contains vba customized functions that contains a range call and the range is in another sheet.
In the Windows Environment the updating of the sheet takes a second or two (the Pc is a four core 3,4 GHz with 6 GB). The apple mac (1,7 GHz, number of cores unknown, 4 GB) it takes at least 5 minutes or 300 seconds.
This is an utterly difference, therefore, is there anything that can be done to the apple mac without rewrite the application?
Thanks in advance
B Anders
I have an Excel application which works fine in Windows (7) and Excel 2010 but perform utterly badly in an Apple Mac with the ordinary office package.
The background:
The application consists of a summary sheet with 13000 cells that contains Formulas. In 1/3 of it is simple formula like =RC + R[3]C[-7] or =sum, the rest contains vba customized functions that contains a range call and the range is in another sheet.
In the Windows Environment the updating of the sheet takes a second or two (the Pc is a four core 3,4 GHz with 6 GB). The apple mac (1,7 GHz, number of cores unknown, 4 GB) it takes at least 5 minutes or 300 seconds.
This is an utterly difference, therefore, is there anything that can be done to the apple mac without rewrite the application?
Thanks in advance
B Anders
Martin Liss
How are you running Excel 2010 on the MAC? I assume you use a Windows emulator (like I do), but which one?
You could run a trial of the mac version of office (office 2011) and see how much quicker it is in it's native environment.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Get Parallels Desktop 8 For MAC. With it, as long as you have the disk for the Windows OS, you can run any version of Windows (and any Windows app) on the MAC virtually seamlessly with OS X. I do it all the time and I see no slowdown when running Excel 2010.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
See my last comment.