PowerPivot "Memory error: Allocation failure" message

Martin289

New Member
Joined
Oct 14, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello everyone,

I have been using Powerpivot on 32bit Excel on company laptop HP Probook 640G4 with 8Gb or RAM for a couple of years with no issues. Recently, I have received a laptop replacement HP Elitebook 745 G6 which also has 8Gb RAM. When trying to refresh the same Powerpivot model, I am now getting the "Memory error: Allocation failure" message.
At first I thought this was due to the lower amount of available RAM (5.93Gb) as the new laptop has 2 Gb RAM dedicated to ATI Radeon Vega graphics. Since I am not able to change the BIOS setting, I added another 8Gb of RAM, however, I still keep getting the same error message. When I reduce the number of rows in the table significantly using query the table will refresh OK. Both PCs are upgraded to the latest Win10 64 bit version and have the same version of Office 365 installed with Excel version in both being Semi-Annual Enterprise 2008 (Build13127.21624).

Does anybody have any idea what could be causing this error on my new PC?
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top