dyaron
Active Member
- Joined
- Nov 26, 2007
- Messages
- 291
Hello all...
I have a spreadsheet that I use to track stocks, but it's built to be used as an application. I have the Iterations tab checked, and the Maximum iterations set at 9999. It seems to be fine for about a week or so, as I use it throughout the week, but every few days, I have to reset this because I'm assuming it's down 9999 calculations. Is there a way I can prevent this from happenening, or "reset" the maximum iterations to 9999 everytime before I open the workbook, or close the workbook. Any suggestions on how to accomplish this, and more importantly, when to do this would be great. Thanks guys!
I have a spreadsheet that I use to track stocks, but it's built to be used as an application. I have the Iterations tab checked, and the Maximum iterations set at 9999. It seems to be fine for about a week or so, as I use it throughout the week, but every few days, I have to reset this because I'm assuming it's down 9999 calculations. Is there a way I can prevent this from happenening, or "reset" the maximum iterations to 9999 everytime before I open the workbook, or close the workbook. Any suggestions on how to accomplish this, and more importantly, when to do this would be great. Thanks guys!