Microsoft Office 2008 for Mac, You Suck

Every try calculating a pivot table in Excel?  How long would you guess it takes for 800 rows of data?  10 seconds?  15 seconds?  How about minutes?  Two minutes?

That’s right.  I’ve got enough time to go post on a blog when I ask Excel to calculate a Pivot Table on 800 rows X 10 columns.  The same task in Excel 2003 (under Parallels) takes about 4 seconds.

Here’s what it looks like every time you need to refresh your pivot tables:

picture-2.png

Just in case you want to save, the new file format (or whatever Excel 2008 does) makes your files about 50x as big as they used to be.  This means a pivot table with a hundred rows of source data will end up being a 20MB file.

My pivot table is almost done being recalculated, so I should get going…

How to Open Two Excel Files Side by Side in Separate Monitors?

Excel for Mac 2008

Sum at a glance

Summarize Dates / Year+Month

Week Numbers, Summarize Data By Week

Conditional Formatting

Calculate Calendar Quarter of Fiscal Quarter From Date