PowerPivot Memory Error – Not Enough Storage
I just got the Professional Microsoft PowerPivot for Excel and SharePoint book and I started working through the tutorials. Well right out of the gate I received an error message – Memory error: Allocation failure : Not enough storage is available to process this command. . The operation has been cancelled. My initial reaction was to check the hard drive space. I had around 15GB of space available, so that wasn’t the issue. I then checked my available memory (RAM). And I had just about nothing left. I went ahead and shutdown every service and application that was not needed, along with restarting my SQL Server database service, so that I just had Excel open.