Excel always crashes on second running of add-in

[philltee]

Hi,

I have a weird issue with a vba macro I am running. the macro opens up another large workbook which performs calculations using an addin called proj_result. This is actually a Prophet add-in (if anyone on here uses Prophet this may be something you can solve).

Basically the workbook calculates fine for the first set of inputs, but once it is finished and I try to save this data then input a new set of variables, the add-in runs so slowly that excel just freezes.

I have tried closing the workbook after the first run, then re-opening the original template, but it still has the same issue of hanging. It seems there is something cached which breaks excel. The only way to get the template to run again is to close excel completely via task manager.

Does anyone know how I can either fully kill the workbook after the first run, so it will not impact the second run when I re-open the template? Or any other suggestions to get around the problem??

 

[chrism216]

You could try running the macro while watching the task manager. That way you could detect any memory leaks, in case theres is faulty programming in that add-in. other than that, trying to fix an add-in is going to be difficult.

You could try to run your macro step by step (F8 mode), until you get to the exact point where it crashes. You might get some insight that way.

Good luck

 

[philltee]

Thanks for the reply Chris. When I F8 through the code, it doesn't error it just runs very slowly. There must be something being cached by the excel add-in...

Any idea how big can kill the workbook completely once I have run it the first time and saved it?

 

[chrism216]

well, that depends on your computer really. But it should never get to that point anyway.

but there must be something which makes it start to go slow. a loop or something?
I'm guessing theres something wrong with your add-in...