One of these users is getting an error that states that there isnt enough memory to complete this action.

To increase memory availability, consider: -using a 64-nit version of Microsoft Excel -Adding memory to your device.

However, with that said, you will NEVER be able to do a pivot table in excel on 500 MB of data, with a computer with 16 gb of ram.

They were trying to manipulate hundreds of MB of data that was exported from a SQL server.

Excel is not made to crunch such large amounts of data, thats why the data was in the SQL database to begin with.

The solution is to find a better tool for whatever job they are trying to do.

Then it was not enough ram, so we upgraded from 4 gb to 16 gb.

At some point the higher ups realized that this person didnt know what they were doing and they have since moved on.

Why Does My Microsoft Excel 2013 Keep Saying Not Enough Memory 32 Bit Office For

MS recommends 32 bit Office for plugin compatibility, not because 64 bit doesnt work.

We dont use plugins, but we do have lots of large Excel files so I moved everyone to 64 bit last year.

All of our issues with memory large files went away and there have been zero problems.

This is not always a fix, but has resolved the issue on some machines when the other steps fail.

Browsers and AV programs would be the first things Id look at.

I reset chrome to disable whatever was causing it to hang when it was opened.

We have many users with 32 bit Excel running ginormous ugly spreadsheets.

Why Does My Microsoft Excel 2013 Keep Saying Not Enough Memory Windows 7 Pro 64

Windows 7 Pro 64 bit OS with 16GB of RAM and pagefile set to auto.