Since morning, I have been getting \u201cOut of Memory\u201d errors when accessing the VBA Editor in MS Excel 2007 .<\/p>\n
I created\/edited a macro that cleaned up and formatted about 1500 rows of purchase order data downloaded from Walmart\u2019s Retail Link\/Orbit site. The macro ran fine and the final sheet had about 300 rows and 16 columns of data that I needed. The problem started when I tried to open this sheet. The sheet takes a long time to load with a \u2018not enough system resource\u2019 message at the end and \u2018out of memory\u2019 message when I tried to open VBA editor to edit the macro.<\/p>\n
After a frustrating half day trying to figure why this happened, I simply took this tip<\/a> and recreated the workbook thru a simple copy-paste. I guess, I should suspect my macro modules. After all, I spent a lot of time editing the module, and they probably became corrupt over time. (This has been a known problem for some time in VBA.)<\/p>\n Also noticed how the file with the same data shrunk from 6MB file went down to 171kb on doing this. Guess this works for the time being and will figure out the cause when I have enough time.<\/p>\n A good discussion on memory problems with Excel can be found at these pages: Since morning, I have been getting \u201cOut of Memory\u201d errors when accessing the VBA Editor in MS Excel 2007 . I created\/edited a macro that cleaned up and formatted about 1500 rows of purchase order data downloaded from Walmart\u2019s Retail Link\/Orbit site. The macro ran fine and the final sheet had about 300 rows and […]<\/p>\n","protected":false},"author":1,"featured_media":3979,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"book_review_cover_url":"","book_review_title":"","book_review_series":"","book_review_author":"","book_review_genre":"","book_review_isbn":"","book_review_publisher":"","book_review_release_date":"","book_review_format":"","book_review_pages":"","book_review_source":"","book_review_rating":"","book_review_summary":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[32,38],"class_list":["post-139","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-problem-soultion","tag-ms-excel","tag-problem"],"jetpack_featured_media_url":"https:\/\/ravi.rajiniravi.com\/blog\/wp-content\/uploads\/2021\/01\/photo-1547139559-c89c59d117611.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/posts\/139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/comments?post=139"}],"version-history":[{"count":0,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/posts\/139\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/media\/3979"}],"wp:attachment":[{"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/media?parent=139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/categories?post=139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/tags?post=139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
http:\/\/www.decisionmodels.com\/memlimitsc.htm<\/a>
http:\/\/www.decisionmodels.com\/memlimitsd.htm<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"