hi Friends,

we have facing High Memory usage problem as soon as open excel 2010 large size Excel Workbook, we have all branded PC with 2GB physical memory installed on it. Users facing performance issue when they open large size  Excel file, we observe that  when users open large size Excel file excel start to uses high memory & Hang a PC, users unable to open others file when open excel sheet.

I have done many changes on computers by searching technet article but useless, We have also checked it by increasing physical memory but still we facing same problem,

Any body has resolution of this problems, then please share a solutions.

Thanks & Regards,

Pardeep

Hi Pardeep,

According to your description, I suppose you are using Excel 2010 32bit version. As far as I know, the Excel 2010 32bit version the max of RAM usage is 2 GB. Thus, if we add more physical memory, 32bit version can't use it. I recommend you use Excel 64bit version to open/edit the large workbook.

The 64-bit version of Excel 2010 is not constrained to 2 GB of RAM like 32-bit applications. Therefore, 64-bit Excel 2010 enables users to create much larger workbooks. 64-bit Windows enables a larger addressable memory capacity, and 64-bit Excel is designed to take advantage of that capacity. For example, users are able to fill more of the grid with data than was possible in previous versions of Excel. As more RAM is added to the computer, Excel uses that additional memory, allows larger and larger workbooks, and scales with the amount of RAM available.

More reference:

https://msdn.microsoft.com/en-us/library/office/ff700514(v=office.14).aspx

http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012/12/18/top-10-list-of-performance-issues-in-excel-workbooks.aspx

Regards,

George Zhao
TechNet Community Support