Excel Cannot Complete this Task with Available Resources - PCSTATS TechTip

[news 28]

Excel Cannot Complete this Task with Available Resources - PCSTATS TechTip

 

QUOTE:

"So, you have a massive 45MB Excel spreadsheet open with multiple pages and you're about to update a few thousand cells when this error box pops up: "Excel cannot continue this task with available resources. Choose less data or close other applications. Continue without Undo?" What to do?! The issue is indeed resources related, but adding more memory will not fix things. Rather, Excel is crapping out when you work with large .xlsx spreadsheets is because 32-bit Excel is installed and 32-bit Excel can only address 2GB of system RAM."

 

URL: http://www.pcstats.com/NewsView.cfm?NewsID=115767

TAG: Excel Cannot Complete this Task with Available Resources - PCSTATS TechTip

 

Automated REVIEW RSS feed: http://www.pcstats.com/rss/rssmedia.xml

Please post a link to this review in your NEWS !

Thanks! PCSTATS