Excel Gantt: Slow Performance

[DrHacker]

Hello Mr. Excel Team Members,

I have an issue with a Gantt Chart Template that I create, something it makes it extremely slow...

I'm not sure if its due the formulas, conditional formatting or other stuff...

Could you please take a look of it and support me to speed it up?

Thanks a lot!!!

Download Link: https://drive.google.com/open?id=1nUopDFCeLkNqPEXdbGnDEKAB0iePAH6a

 

[Sam_D_Ben]

Re: Excel Gantt: Slow Performance - Support request

Checked your macro, I guess you can shorten it. If you could paste your code here, there are experts here that can help you with it. Other functional formulas seems fine.

 

[DrHacker]

Re: Excel Gantt: Slow Performance - Support request

Checked your macro, I guess you can shorten it. If you could paste your code here, there are experts here that can help you with it. Other functional formulas seems fine.

I dint notice that the file has Macro protection (View)

Updated file doesn't have protection anymore.

Just in case, here is the link again:

https://drive.google.com/open?id=1nUopDFCeLkNqPEXdbGnDEKAB0iePAH6a

 

[DrHacker]

Re: Excel Gantt: Slow Performance - Support request

I dint notice that the file has Macro protection (View)

Updated file doesn't have protection anymore.

Just in case, here is the link again:

https://drive.google.com/open?id=1nUopDFCeLkNqPEXdbGnDEKAB0iePAH6a

Some one had a chance to take a look to support me?

Support its really appreciated.

Thanks!!!