Excel "power" user...business application???

Yes. Office still sucks for anything more advanced than SUM(xx:xx).

 

Not sure if Excel 2008 for mac does macros. If you use macros, stick with PC I would say... TBC

 

Excel 2008 does not support VBA (hence no macros). I had used 2004 at home and had exchanged some files with 2003 and for the most part went well (VBA in 2004 is based on VB5 which is the equivalent of XL 97). Formulas and data were no problem. I do not use 2008 (nor 2007) due to job changes in the last 2 years.

As for file format, the files should be exchanged with no problems. Likewise functions, although there are some gotchas. The Data Analysis Toolpak is gone, but many of those have been incorporated into the functions, others not because they rely on VBA. Also, if you have any circular references in formulas that work fine in 2007, you may find trouble exchanging them with 2008.

I think you can get a 30 day trial of 2008. Take a random sampling of your spreadsheets and see what happens.

 

Macros are a big issue to some, like me, and those are simply not on the Mac version. Hell, I can't even take my files to most Win computers and use them since mine is set up with more "stuff". And since the latest versions (2007, 2008) have all sorts of inter-operability with other Office programs, it is pretty easy to have something embedded in a Win.xlsx that a OSX.xlsx can't handle. I actually still use 2003/2004, so I don't have any anecdotes about 2007/2008.

I think one of the next versions is due next year, maybe both Win and Mac.

 

Office for Mac 2010 is on the horizon, but I've not seen an official anticipated release date. It is supposed to restore VBA.

 

I think you may be refering to Numbers, sadly.

 

You might want to contact Jim McGimpsey, who is a Microsoft MVP for Mac Office.

 

Complex Excel

I do statistical analyses for my research and have not had any issues with Excel 2008 sharing files. True, no macros, but the data are fine and so are the formulas. I use "database" (lousy term) functions to locate data in dozens of tabs for a top sheet that summarizes data.

Not one issue.

I move the data to SPSS for serious crunching, without a glitch. The results are the same, PC or Mac.

Yes, I miss VBA. No, it hasn't ruined my life. I actually use some AppleScripts for tasks and it works fine. I grab data from some static Excel files, so VBA would make life better.

I get data from MySQL queries, dump to Excel, then analyze in SPSS. The workbooks are up to two dozen tabs, various links between them.

As I said, not a single difference in the numeric results. In the past, I also had issues with Excel on the Mac having a "smaller" (fewer columns or rows) sheet. No problems this year.

 

Well, as I mentioned, I don't use the latest versions, yet. But I've not had any problems related to functions. And I have some complex things going on. Both the 2007/2008 versions are more capable than mine, I doubt you'd see a decrease in capability of 2008 vs the 2004 version I have for Mac.

3 dozen sheets, interlinked for financial models sounds pretty simple (in terms of Excel processing), actually. I'm assuming simple math functions and rate calculations? Some graphs? Should be fine. Going between sheets isn't an issue. Correct me if I'm wrong.

Make sure you switch the Mac version to the 1900 date system.

There are comments around the web about color palettes not matching perfectly. But that could be true from one monitor to another, let alone different OSes.

External links to other workbooks can be tricky. But that isn't a Win vs OSX issue, not entirely. Easiest just to avoid that on shared files, or ones that get sent outside of your office.

 

Do not bother with Excel for Mac if you use anything even mildly intensive in it. It is slow like the old 386 and any old Windows machine, even loaded with spyware and viruses, will run circles around any super-duper Mac Pro running Excel 08.

There are many reasons to get a Mac. Excel is NOT one of them.

 

Tom, I do a lot of financial modelling with Excel on Office 2008 ( I am an Accountant) and exchange files with everyone else in the office that uses windows without problems, I always avoid external links on spreadsheets as they are easy to screw up, if you move the source file (so I can't comment if this as a real issue between OS's). I don't use Macro's and I tend to keep the file in excel 2003 format for maximum compatibility (most of the office is not using the latest version).

Microsoft have released a service pack that has improved the speed of Excel 2008, but it is still noticeably slower than windows Excel if you have a lot of lookups and recalculating formula.

 

Even if a spreadsheet has many cells interlinked it will be fine between OS X/Windows. Besides VBA, the only things that really don't work between the two are charts and graphs.

 

I have some pretty complex spreadsheets that we exchange from Windows to Mac as well without issues. The date issue is real but, I think, only for new spreadsheets created on the Mac (solution). Ultimately you should update your template if you are creating new spreadsheets to share with Windows users. Spreadsheets created by Windows users for you should be ok (this option will be set already). Once you set this flag and save it as a template the problem goes away for good.

Other than that the only issue is that Excel 2008 is more similar to a ~3 year old Windows version in appearance. The features (except those mentioned above) are there though).