CODEWITHSUNDEEP
excelmemory-leaksout-of-memoryexcel-2016vba
trubby317
trubby317

Reputation: 49

Excel 2016 upgrade causing a memory crash

I came back from vacation to see all of my Excel applications crash after a few seconds/minutes of running. With the new upgrade to 2016, there seems to be some weird behavior.

For example, the below works totally fine

Sub Test1()
  for i = 1 to 10000000
    temp1 = 4 + 6
  next i
End Sub

The following, however, causes my excel to crash in a couple of seconds as the memory needed in my TaskManager just keeps climbing to over 1.5GB

Sub Test2()
  for i = 1 to 10000000
    temp1 = worksheetfunction.Min(5,7)
  next i
End Sub

I'm guessing I'll have to revert to 2013 as I have thousands of lines of code that will most likely need modification (not sure to what though)

Any ideas what could be causing this and a solution?

Thanks

Upvotes: 1

Views: 6295

Answers (3)

Robert McAlister
Robert McAlister

Reputation: 21

This was fixed back a few months ago and today I see 2 memory leaks. It's back!

Microsoft updated last night... Jun 14/2016

Upvotes: 0

user5859658
user5859658

Reputation: 21

I want to let you know that the Excel team recently fixed this issue. The fix is in build 16.0.6366.2062, which started rolling out on 1/25. If you don't see the update yet, go to File > Account > Update Options > Update Now.

(source)

Upvotes: 2

user5749011
user5749011

Reputation: 26

Hi sorry you are hitting this. I have posted a workaround for the problem here. Please let me know if that does not resolve your issue. We will have a more permanent fix very soon.

http://answers.microsoft.com/en-us/office/forum/office_365hp-excel/excel-2016-macro-crashes-sometimes-gibes-an-out-of/37a7df04-9d1b-4b6b-b107-e8d0971e324e

-Tyson Murray Excel

Upvotes: 1

Related Questions