Login Page - Create Account

Support Board


Date/Time: Tue, 24 Dec 2024 12:22:32 +0000



unable to edit or change formula in spreadsheet

View Count: 828

[2015-11-04 12:36:27]
kam2001 - Posts: 79
Hi, Everytime i change or edit any empty cell or previous formula in spreadhseet, it defaults back to previous value or empty cell. I tried to disconnect and than change value and save .scwbf file, but when i connect again it defaults to old values in the sheet. Seems like some sort lock on sheet/chartbook.

Thanks
[2015-11-04 17:17:15]
Sierra Chart Engineering - Posts: 104368
If you are using the Spreadsheet study, what you describe is the result of the Formula Source Sheet Number input not being set correctly:
https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudyInputs.html#FormulaSourceSheetNumber
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
[2015-11-04 18:05:54]
kam2001 - Posts: 79
Yes, that helped. Thanks..I was updating sheet 4 when the Formula source sheet was 3.

Thanks

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

Login

Login Page - Create Account