Workarounds for 'Canceled Due to Memory Pressure'

Ah, the dreaded dialog:

The Operation Has Been Cancelled Due to Memory Pressure

You can run into this error via a number of different routes, but one way or another, your computer ran out of memory while PowerPivot was trying to do something.