Excel 2016 and Betangel slowing up and not responding
I run 4 instances of BA with multiple spreadsheets betting on horse races. Since I have begun using Excel 2016, after 2 or 3 hours BA and SS appear to become bogged down and unresponsive even though the work load has not increased. Can anyone shed some light on wether I need and add in or to remove and add in or something that may cause this ?
VB (visual basic) and macros are one and the same. Your problems could be down to a number of things.
Some formulas are more resource hungry than others, if you have finished with a sheet have you cleared any not needed?
Graphs can aslo slow it down.
Do you use loops in your code?
Has your code been fully qualified? As you are running several instances of excel, there could be instances where the code is referencing an incorrect workbook/sheet.
Is your code in a module or used in an event?
If you can post a sample, it might help narrow the field a bit.
Some formulas are more resource hungry than others, if you have finished with a sheet have you cleared any not needed?
Graphs can aslo slow it down.
Do you use loops in your code?
Has your code been fully qualified? As you are running several instances of excel, there could be instances where the code is referencing an incorrect workbook/sheet.
Is your code in a module or used in an event?
If you can post a sample, it might help narrow the field a bit.
My first thought is that memory is being used up and not released.
Possibly a bug in Excel 2016 since you imply everything was fine with Excel 2010 or recent changes not releasing memory.
Monitor memory usage with Task Manager performance / Resource Monitor and see if Excel memory just keeps growing. Also monitor the usage per BA instance to see if one set of strategies is the guilty party.
Another thing to consider is what other changes have been made since you used 2010 (eg new version of BA, new PC, Windows version, etc) - have those changes broken things and nothing to do with 2016 ?
Possibly a bug in Excel 2016 since you imply everything was fine with Excel 2010 or recent changes not releasing memory.
Monitor memory usage with Task Manager performance / Resource Monitor and see if Excel memory just keeps growing. Also monitor the usage per BA instance to see if one set of strategies is the guilty party.
Another thing to consider is what other changes have been made since you used 2010 (eg new version of BA, new PC, Windows version, etc) - have those changes broken things and nothing to do with 2016 ?
Thanks all for the replies ! I currently studying software development and will clean things up when I can. Clearing a sheet after an event may free up resources. It seems most likely that garbage collection is insufficient as this problem begins after many events have ended. I have attached the excel file.
Thanks,
Russell
Thanks,
Russell
You do not have the required permissions to view the files attached to this post.