When it starts going off the rails like that I also ask it to "check its work when its done", and it seems to extend the amount of usable time before it loses the plot and suggests i use VBA or something.