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

HKFuey
HKFuey used Ask the Experts™
on
I found the answer hotfix released March 2017: -
excel2010-kb3191855-fullfile-x86-glb.exe
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
See above

Author

Commented:
Macros now working!!
Jan Karel PieterseExcel and VBA Expert

Commented:
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

Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Roy CoxGroup Finance Manager

Commented:
HKFuey

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

Author

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

Author

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial