Excel Memory Error

Issue/Question

Excel 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.

Environment

  • Microsoft Excel

Cause

32-bit version of Office installed

Large data file

Resolution

  1. Uninstall Microsoft Office
  2. Reinstall Microsoft Office
    Note: 64-bit version is installed by default
  3. Test application
    Note: Older files that have been converted to newer excel formats may report this error.  Save file in .xls format and test functionality
Print Article