If not, try once and then go below to read this article.
I faced this type of problem when I was working on one of my project and this project uses MS Excel to prepare the reports and these excel were of size almost more than 100 MB with lot of Excel complex formulas in it.
Excel doesn't work if there are lot of formulas in the spreadsheet. This is due to the fact that each excel cell formula occupies memory. And if you are trying to open these excel files with complex formulas the excel throws an error saying "Not enough resources".
Does someone knows why you get this error? If No, then here is the explanation......
This issue is due to the fact that this excel file has already reached the maximum memory limit per process on a 32-bit OS i.e 2GB per Process limit. This is the reason you will not be able to open an excel file that crosses 2GB memory on 32-bit OS.
This process can be eliminated if we use 64-bit OS with 64-bit Office Excel (if available), as 64-bit OS allows more than 2GB per process support.
In my case, I tried with Office 2010 on Windows 2008 or windows 7 and it worked (excel file has utilized more than 5 GB of memory)
So next time when you face this type of issue don't blame Office Excel but think broadly and try other alternatives.
No comments:
Post a Comment