Home

An extremely odd bug in Excel 64 bit. Causing huge problems

%3CLINGO-SUB%20id%3D%22lingo-sub-803876%22%20slang%3D%22en-US%22%3EAn%20extremely%20odd%20bug%20in%20Excel%2064%20bit.%20Causing%20huge%20problems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803876%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20Excel%20screen%20that%20is%20populated%20with%20images%20that%20refer%20to%20cell%20values.%26nbsp%3B%20In%20addition%2C%20I%20have%20columns%20of%20data%20that%20are%20populated%20with%20tag%20names%20in%20another%20sheet%20of%20the%20same%20workbook.%3C%2FP%3E%3CP%3EI%20have%204%20laptops%20running%20the%20same%20program%2C%20two%20with%201090P%20and%20the%20others%20being%20a%202460x1800%20and%20the%20last%20one%20being%204K.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESomething%20first%20happened%20with%20the%204k%20laptop%20about%202%20weeks%20ago%2C%20the%20screen%20populating%20being%20slow%20then%20resulting%20in%20a%20stack%20overflow.%26nbsp%3B%20The%203%20remaining%20laptops%20were%20OK%20then%20the%202460%20unit%20started%20exhibiting%20the%20same%20behavior%2C%20was%20really%20slow%20crashing%20on%20a%20stack%20overflow.%26nbsp%3B%20The%20remaining%202%201080ps%20are%20doing%20fine%20as%20of%20now.%20I%20suspended%20all%20updates%20as%20apparently%20this%20is%20a%20problem%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%3Bve%20narrowed%20it%20down%20to%202%20problems.%26nbsp%3B%20The%202%20bricked%20excel%20program%20computers%20take%20over%208%20seconds%20to%20do%20the%20same%20subroutine%20-%20sub%20mainscreenpopulate()%20that%20the%20other%20two%20working%20computers%20take%20only%201.5%20seconds%20to%20do.%26nbsp%3B%20I%20found%20that%20the%20main%20time%20consumption%20of%20the%20non-working%20excel%20is%20simply%20writing%20individual%20cells%20of%20another%20spreadsheet%20in%20the%20same%20workbook%20to%20the%20main%20screen%20spreadsheet.%26nbsp%3B%20What%20to%20heck%20is%20going%20on%3F%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20other%20problem%20is%20that%20the%20sub%20mainscreenpopulate()%20is%20apparently%20called%205%20times%20in%20succession%20without%20the%20darn%20sub%20call%20finishing.%26nbsp%3B%20Indeed%2C%20I%20got%20a%20timer%20at%20the%20beginning%20of%20the%20subroutine%20and%20timer%20at%20the%20end%20of%20the%20same%20**bleep**%20routine%20and%20I%20can%20see%20that%20each%20time%20the%20sub%20is%20called%20it%20doesn't%20finishing%20until%20about%205%20times%2C%20then%20the%20timer%20at%20the%20end%20of%20the%20sub%20will%20start%20logging!!!%3F%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20oddest%20behavior%20I've%20ever%20seen.%26nbsp%3B%26nbsp%3B%20How%20is%20it%20a%20sub%20gets%20called%20over%20and%20over%20before%20it%20is%20finished%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20so%20**bleep**%20weird%20I%20am%20at%20my%20wits%20end.%26nbsp%3B%20I%20got%202%20working%20computers%20and%202%20non%20working%20computers%20each%20set%20exhibiting%20the%20same%20inexplicable%20things.%26nbsp%3B%20Help!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-805988%22%20slang%3D%22en-US%22%3ERe%3A%20An%20extremely%20odd%20bug%20in%20Excel%2064%20bit.%20Causing%20huge%20problems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-805988%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F277958%22%20target%3D%22_blank%22%3E%40rpbenz%3C%2FA%3EI%20have%20two%20other%20laptops%20with%20an%20I3%20that%20complete%20this%20code%20in%20less%20than%20.15%20seconds%3A%3C%2FP%3E%3CP%3E'%20For%20I%20%3D%200%20To%20180%3CBR%20%2F%3E'%20Sheet1.Cells(3%20%2B%20I%2C%2021)%20%3D%20Sheet2.Cells(k%20%2B%20I%2C%202).Value%20%26amp%3B%20%22%3A%22%3CBR%20%2F%3E'%20Next%20I%3C%2FP%3E%3CP%3EYet%20my%20new%20I7takes%20over%206%20seconds%20to%20do%20this%20same%20code.%26nbsp%3B%20The%20same%20phenomena%20is%20happening%20with%20another%20laptop%20with%20an%20I5.%26nbsp%3B%20Why%3F%3F%3F%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20a%20week%20ago%20they%20were%20doing%20the%20same%20code%20no%20problems.%26nbsp%3B%20There%20was%20an%20update%20to%20excel%20but%20they%20all%20have%20the%20same%20build%20now.%26nbsp%3B%20I%20don't%20get%20whats%20going%20on%3F%26nbsp%3B%20Ive%20virus%20checked%20and%20now%20am%20doing%20a%20code%20rewrite%20for%20the%20screwed%20up%20computers%20using%20range%20command%20but%20I%20am%20worried%20using%20Excel%20might%20be%20screwed%20up%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-809677%22%20slang%3D%22en-US%22%3EProblem%20with%20Excel%20Version%201907%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-809677%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20face%3D%22arial%20black%2Cavant%20garde%22%3E%3CSTRONG%3EStay%20away%20from%20Excel%20%3C%2FSTRONG%3E%3C%2FFONT%3E%3CEM%3E%3CSTRONG%3EVersion%201907%20(Build%2011901.20218)%3C%2FSTRONG%3E.%26nbsp%3B%20%3C%2FEM%3EThis%20version%20totally%20screwed%20up%20my%20VBA%20application%2C%20causing%20weird%20behavior%20such%20as%20incredibly%20long%20times%20when%20simply%20writing%20to%20cells%20via%20a%20for-next%20loop%3A%3C%2FP%3E%3CP%3E'%20For%20I%20%3D%200%20To%20180%3CBR%20%2F%3E'%20Sheet1.Cells(3%20%2B%20I%2C%2021)%20%3D%20Sheet2.Cells(k%20%2B%20I%2C%202).Value%20%26amp%3B%20%22%3A%22%3CBR%20%2F%3E'%20Next%20I%3C%2FP%3E%3CP%3EI%20spent%20a%20good%20week%20trying%20to%20figure%20out%20why%20the%20code%20locked%20up%20on%20one%20computer%20but%20not%20the%20other%20and%20only%20resolved%20the%20problem%20by%20rolling%20back%20to%20Version%201905.%26nbsp%3B%20I%20thought%20that%20Microsoft%20had%20their%20act%20together%20but%20apparently%20they're%20still%20having%20problems%20with%20their%20work.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-815535%22%20slang%3D%22en-US%22%3ERe%3A%20An%20extremely%20odd%20bug%20in%20Excel%2064%20bit.%20Causing%20huge%20problems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815535%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F277958%22%20target%3D%22_blank%22%3E%40rpbenz%3C%2FA%3E%26nbsp%3BHello!%20You've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FCommunity-Discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ECommunity%20Discussion%20space%3C%2FA%3E%2C%20which%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3EExcel%20space%3C%2FA%3E%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
rpbenz
New Contributor

I have an Excel screen that is populated with images that refer to cell values.  In addition, I have columns of data that are populated with tag names in another sheet of the same workbook.

I have 4 laptops running the same program, two with 1090P and the others being a 2460x1800 and the last one being 4K.

 

Something first happened with the 4k laptop about 2 weeks ago, the screen populating being slow then resulting in a stack overflow.  The 3 remaining laptops were OK then the 2460 unit started exhibiting the same behavior, was really slow crashing on a stack overflow.  The remaining 2 1080ps are doing fine as of now. I suspended all updates as apparently this is a problem

 

I;ve narrowed it down to 2 problems.  The 2 bricked excel program computers take over 8 seconds to do the same subroutine - sub mainscreenpopulate() that the other two working computers take only 1.5 seconds to do.  I found that the main time consumption of the non-working excel is simply writing individual cells of another spreadsheet in the same workbook to the main screen spreadsheet.  What to heck is going on?? 

 

The other problem is that the sub mainscreenpopulate() is apparently called 5 times in succession without the darn sub call finishing.  Indeed, I got a timer at the beginning of the subroutine and timer at the end of the same **bleep** routine and I can see that each time the sub is called it doesn't finishing until about 5 times, then the timer at the end of the sub will start logging!!!???

 

This is the oddest behavior I've ever seen.   How is it a sub gets called over and over before it is finished?

 

This is so **bleep** weird I am at my wits end.  I got 2 working computers and 2 non working computers each set exhibiting the same inexplicable things.  Help!!!

3 Replies

@rpbenzI have two other laptops with an I3 that complete this code in less than .15 seconds:

' For I = 0 To 180
' Sheet1.Cells(3 + I, 21) = Sheet2.Cells(k + I, 2).Value & ":"
' Next I

Yet my new I7takes over 6 seconds to do this same code.  The same phenomena is happening with another laptop with an I5.  Why?????

 

Just a week ago they were doing the same code no problems.  There was an update to excel but they all have the same build now.  I don't get whats going on?  Ive virus checked and now am doing a code rewrite for the screwed up computers using range command but I am worried using Excel might be screwed up

Stay away from Excel Version 1907 (Build 11901.20218)This version totally screwed up my VBA application, causing weird behavior such as incredibly long times when simply writing to cells via a for-next loop:

' For I = 0 To 180
' Sheet1.Cells(3 + I, 21) = Sheet2.Cells(k + I, 2).Value & ":"
' Next I

I spent a good week trying to figure out why the code locked up on one computer but not the other and only resolved the problem by rolling back to Version 1905.  I thought that Microsoft had their act together but apparently they're still having problems with their work. 

 

 

@rpbenz Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
12 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies