I wouldn't try and get PC Excel files working with Excel for Mac, its a different beast, especially for the more complex macros etc. Just don't..!
You could use Parallels to enable Windows to be run on the Mac at the same time, then have office for windows installed. Bumps the bill up even more though