You're correct, and Excel for Mac also doesn't support the PowerPivot addon either. However, that still doesn't mean you can fault Excel for barely being able t

You're correct, and Excel for Mac also doesn't support the PowerPivot addon either. However, that still doesn't mean you can fault Excel for barely being able to cope with a use case it isn't designed to support. The fact that it can handle it at all is a testament to the versatility of the program, not the other way around. It simply isn't the correct tool for the job, and shouldn't be faulted for subpar performance in a scenario it wasn't designed for. Writing code in Word is completely possible, but would you fault Microsoft for the ensuing bad experience? You can also use Eclipse for writing a resumé, but would you fault it for not supporting that use case very well?