Qlink "You cannot change part of an array" error

[demarcog]

I installed Qlink and used the tool to populate a spreadsheet and I see price data populate the spreadsheet, but occasionally when I select a cell in I receive the messagereceiving message:

"You cannot change part of an array".

I also cannot perform any excel functions, close the spreadsheet, save it, or even exit excel, "cannot quit Microsoft Excel". I have to task manager terminate Excel.

In addition when I open the spreadsheet after closing it the real time prices updates do not populate the spread, yet when I then open the sample spreadsheet Qlink.xls prices are populating?


Thanks,


Glen

[eSignal_AveryH]

Hey Glen.

I've run into this many time trying to make changes to the QLink cells and it was just recently I found out through JayF that the best way to get out of the never ending array error is to hit the ESC key.

If you would like to make changes to the array you would need to highlight the entire array, make the necessary changes and then hit Control/Shift/Enter for the worksheet to accept the changes.


Hope this helps.

AveryH
eSignal Support