Link to home
Start Free TrialLog in
Avatar of HKFuey
HKFueyFlag 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
ASKER CERTIFIED SOLUTION
Avatar of HKFuey
HKFuey
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of HKFuey

ASKER

Macros now working!!
Avatar of 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

HKFuey

It's not in the spirit of any help forum to delete the question and not share the solution. Very poor forum etiquette!
Avatar of HKFuey

ASKER

Did you not read this: "I found the answer hotfix released March 2017: -
excel2010-kb3191855-fullfile-x86-glb.exe"
Avatar of 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.