Home >> Support Board

Support Board

Date/Time: Wed, 24 Apr 2024 05:10:58 +0000

How to Post a Message for Support

WorkbookSet is locked

View Count: 3059

[2013-06-03 14:57:39] #1 [Go To First Post]
RMF2 - Posts: 43
On a spreadsheet study, I am getting the warning: WorkbookSet is locked! The message log shows: Exception caught from study function. What does this mean? How can I fix it? The warning on the spreadsheet says to see the SpreadsheetGear.IWorkbookSet.GetLock documentation. I wasn't able to locate this on the site. Thanks.

[2013-06-03 16:14:24] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Go to the spreadsheet and select Spreadsheet >> Workbook Explorer. On the left side of the Workbook Explorer you will see the different Books and Sheets listed. Select each one and check the Protection settings on the right to make sure they are disabled. There are separate protection settings for the Books and Sheets. So check each one. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing

[2013-06-03 16:55:39] #3 [Go To First Post]
RMF2 - Posts: 43
The protection settings for the books and sheets were all disabled/unchecked.

[2013-06-03 18:57:34] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Close the spreadsheet and then go to File >>Open Spreadsheet and delete the spreadsheet file. A new one will be created by the Spreadsheet study. If there are formulas on the existing spreadsheet, then make a copy of those first and then put them into something like a text editor and paste them into the new spreadsheet. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing

[2013-06-03 18:59:28] #5 [Go To First Post]
RMF2 - Posts: 43
I got it working again. I attempted a few things before I got it working again. I removed the spreadsheet studies and tried to add a new spreadsheet. The new spreadsheet would not show any data and it showed the WorkbookSet Lock error. Rebooting didn't seem to change anything either. Then I upgraded to version 982 and now I can open a new spreadsheet study without the error. I'll have to rebuild my prior spreadsheet studies but at least it's working again. I don't know why upgrading made a difference but it did. Anyway, thanks for looking into this. It can be closed out.

[2013-06-03 19:02:20] #6 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Makes no sense. Nothing has changed in newer versions which would change this. Anyway, at least it is now working. This is one of many reasons why we are developing our own spreadsheet functionality, to eliminate problems like this. We really do not know what the underlying cause is. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account: