Excel Mac 2008 very slow with pivot table calculations

[.]

Hello
I just upgraded from office 2004 to 2008.
I'm working extensively with excel (pivot tables, getpivodata() etc...)
I found out that it is almost impossible to work with my pivot tables
with Excel 2008 (around 5000 lines of data in my case) : calculations
are very long (20 secs on 2004 and now 2 minutes on 2008 for the same
file !)
every time you move something, open, save, delete,insert row, it
recalculates so 2 mins to wait after each action is not possible

i moved back to 2004 for the moment

Is it a known issue?

i am running a powerbook G4, 1,67GHz with 2GB of RAM, OSX 10.4.11, file
opened localy on my hard drive


Stephane
sa (@) port-adhoc (.) com

 

[Mr. H]

I've seen major performance issues in Excel 2008 on a 1.83 GHz Core Duo MacBook with 1 GB RAM and 10.4.11.

Creating an X-Y chart with two lines, each with 1201 points, takes 3 minutes (including time taken to format the graph - e.g. label axes, move one of the lines to secondary axis, change axes ranges etc.) in Excel 2004.

It takes *13* minutes in Excel 2008! Note that Excel 2004 is running via Rosetta emulation on my machine, so that result is even more damning than it at first appears. Excel 2008 has serious performance issues (oh yeah, it also used 4 times as much RAM (400 MB in 2008 Vs. 100 MB in 2004) and hopefully they are relatively easy to fix rather than a result of poor programming from the bottom up.