Create smart art org chart with VBA incredibly slow

[Jvanderschelling]

The vba code below generates an org chart based on a simple excel table. It works fine for a small org chart consisting up to 30 nodes. However when I try to create an org chart of more than 100 nodes it gets insanely slow. It runs for 20 minutes or so before completing the org chart.
How can I make this code run faster?

Please Login or Register  to view this content.

[jeffreybrown]

Nothing immediately jumps out as needing a tweak to speed up the SmartArt, but you could try turning off more than just Application.ScreenUpdating

See this >> https://stackoverflow.com/questions/...-macro-running

Do you have a small sample file to test?

[Jvanderschelling]

Jeff,
I added a sample file. Appreciate suggestions for speeding up the code!
Thanks.
Johan.