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: