Login Page - Create Account

Support Board


Date/Time: Sat, 30 Nov 2024 05:52:30 +0000



Saving Spreadsheet changes

View Count: 351

[2022-12-13 11:25:21]
User299107 - Posts: 55
HI,

I've recently added new formulas to the spreadsheet - saved it - minimized the SS - but when I maximize it, the new formulas have gone.

Can someone shed some light on this please

thanks,

Eliza
[2022-12-13 16:18:08]
John - SC Support - Posts: 36350
Make sure you have the correct sheet selected and that it did not change when you minimized/maximized (it should not have, but check this).

If you are using a Spreadsheet Study, then check to see if the "Formula Source Sheet" in the Inputs for the Spreadsheet Study is set to a different number than the Chart number. Also, at the top of the sheet at D1 is the information for the Formula Source Sheet, you can check that as well to make sure it is set to be the same sheet as the one that is pulled up at that time. Refer to the following for more information on Formula Sheets:
Spreadsheet Study Inputs: Formula Source Sheet Number
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2022-12-13 20:08:54]
User299107 - Posts: 55
I have checked the Sheet number and it is consistent with the chart no.

However, I notice that the Spreadsheet doesn't autofill down the column after entering the formula, and again, it failed to save after minimizing.

Am I missing something?

Eliza
[2022-12-13 20:48:47]
User299107 - Posts: 55
sorted - I was using the wrong sheet

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

Login

Login Page - Create Account