Solved Using Excel 2013 to open .xls file get error opening file

September 17, 2015 at 12:47:53
Specs: Windows 7
When opening a .xls file with Excel 2013, periodically receive the following error: There isn't enough memory to complete this action. Try using less data or closing other applications. To increase memory availability, consider: -Using a 64-bit version of Microsoft Excel. - Adding memory to your device.

The spreadsheet is not large ( 231 kb). The computer has 4 GB of RAM, Windows 7 Pro SP1 32-bit, Office 2013.

This problem does not occur all the time. It is sporadic and irritating. It's not a show stopper, as you can easily get the file opened eventually by opening the file in a different excel session.

The page file size is fine (3071 MB), turned off hardware graphics acceleration in options.

This error only occurs when opening the file. It's not just one certain file.

The files are .xls because they are sent to people who may not have the newer versions of Office.

At one point, I actually removed Office 2013 altogether and re-installed, but the problem came back.

I'm out of ideas. If anyone has answers or possibilities, I would love to hear (read) them....

See More: Using Excel 2013 to open .xls file get error opening file

Report •

September 17, 2015 at 13:23:00
✔ Best Answer
You can try switching off Dynamic Data Exchange.

For Office 2013 - Advanced > General > Tick the option - Ignore other applications that use Dynamic Data Exchange (DDE)

See if that helps.


Report •
Related Solutions

Ask Question