Did you receive this error message from PowerPivot?
Memory error: Allocation failure : Not enough storage is available to process this command. .
The operation has been cancelled.
Well…you’re probably using PowerPivot’s 32-bits version, more info: InstallPowerPivot.com
“The PowerPivot add-in runs as an extension of Excel and the PowerPivot Vertipaq in-memory engine loads within the same process space. As 32-bit Excel is limited to a 2GB virtual address space. Once you start adding up all of the uses of those virtual addresses, you will find that the largest PowerPivot workbook that you can create on a 32-bit machine is something like 500-700MB. Excel, all of the add-ins, the in-memory database itself and all of the rest just takes up lots and lots of space.” by Dave Wickert
Open Task Manager and locate Excel:
What shall I do?
– Close all other PowerPivot workbooks which are active (if there are any)
– Reduce the imported datasets/tables by applying filters (in the Table Import Wizard)
– Close Excel (and all PowerPivot workbooks) to clear the memory and re-open that particular PowerPivot workbook
– Install the 64-bits version of PowerPivot (also requires a 64-bits version of Microsoft Excel), more info: InstallPowerPivot.com