Excel Memory Error

Summary

Resolving Excel memory error message

Body

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

Details

Details

Article ID: 6304
Created
Tue 5/4/21 10:24 AM
Modified
Wed 7/5/23 2:05 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated