BA affects other Excel programs

[Roger]

This is not a complaint, because I found the solution to the problem, LOL.

I had been having problems running other spreadsheets while BA was logging races into my "Sheet1" spreadsheet. Every time BA talked to the spreadsheet, my other spreadsheet was interrupted, and the cursor was changed to an hourglass icon. When filling down a formula in a large spreadsheet, it happened in jerks, rather than in a smooth progression down the sheet. The worst problem was that Autofilter hung, and in one instance, part of the Autofilter menu appeared in the Sheet1 spreadsheet!

The other spreadsheet had been opened by double-clicking on its name, and this opens the spreadsheet in the same instance of Excel, so both spreadsheets are effectively sharing the Excel interface to BA. The problem was solved by starting a new instance of Excel, and using File, Open to start the second spreadsheet.

[MarkRussell]

Hi,

If you want to get the best possible performance from Betting Assistant then I would not recommend using the PC for other tasks especially anything that might use bandwidth, but of course that is something you need to decide for yourself.

Regards,
Mark

[Castillo]

The problem was solved by starting a new instance of Excel, and using File, Open to start the second spreadsheet.

Roger

Thanks for that, I was getting similar problems myself.

However, if you open the excel file from a shortcut, you can modify the shortcut properties to open a new instance of excel each time:-

Right-click the shortcut and choose Properties, enter

"C:\Program Files\Microsoft Office\Office\EXCEL.EXE" / c:\filename.xls

The first part is the path to your Excel program, and the second part is the Excel file that you wish to open.

Now when you double-click on this shortcut, your file should open in a new instance of Excel.

Hope this helps,

Cheers
Castillo