Avatar of HKFuey
HKFuey
Flag for United Kingdom of Great Britain and Northern Ireland asked on

XL Macro Crashes on one PC only. Automation error the object invoked has disconnected from its clients

I found the answer hotfix released March 2017: -
excel2010-kb3191855-fullfile-x86-glb.exe
VBAMicrosoft ExcelWindows 7Microsoft Office

Avatar of undefined
Last Comment
HKFuey

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
HKFuey

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
HKFuey

ASKER
Macros now working!!
Jan Karel Pieterse

I've seen cases where it helps to insert an Application.Calculate between lines 9 and 10. ALternatively, a DoEvents at the same point might also help.
As a side note, this SUMPRODUCT formula can be efficiently replaced with a SUMIFS formula:

ActiveCell.Formula = "=SUMIFS(OrderBook!$K$2:$K$" & lngOrderBookLastRow & _
    ",OrderBook!$B$2:$B$" & lngOrderBookLastRow & ",Master!$A3,OrderBook!$N$2:$N$" & lngOrderBookLastRow _
    & ","">0"",OrderBook!$N$2:$N$" & lngOrderBookLastRow & ",""<=""&$B3)"

Open in new window

Roy Cox

HKFuey

It's not in the spirit of any help forum to delete the question and not share the solution. Very poor forum etiquette!
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
HKFuey

ASKER
Did you not read this: "I found the answer hotfix released March 2017: -
excel2010-kb3191855-fullfile-x86-glb.exe"
HKFuey

ASKER
@ Roy_Cox I found the answer before there were any other posts, I could have deleted the question but wanted to be helpful.