Support Board
Date/Time: Sat, 20 Dec 2025 06:44:28 +0000
Spreadsheet system - lost settings
View Count: 130
| [2025-11-01 09:27:20] |
| Judge Kilday - Posts: 30 |
|
HI Support: I was cleaning up old Analysis from my chartbook. Now when I re-open Sierra chart, the spreadsheet system for trading I was using is there, but it has lost all the formatting settings (like number formats, background colours) and lost the top line of data in row 1, and lost the variables I had set in the user defined cells J119 - J125. Plus when I try to change a formula in row 2, it does not copy that change all down the column as it did before. Can I restore this? When I tried restoring the chartbook from the previous day, it did not work and still has lost all the formatting settings for the spreadsheet system. |
 Screenshot 2025-11-01 at 09.21.16.png / V - Attached On 2025-11-01 09:25:53 UTC - Size: 150.05 KB - 31 views |
| [2025-11-03 14:22:33] |
| John - SC Support - Posts: 43555 |
|
We can not say what may have occurred, as there is a fair amount of complexity to how the Spreadsheet Studies can be setup. The best option is to recover the actual spreadsheet file from your backups and see if that will resolve the issue for you. The backups are in a folder named "Backups" in your main Sierra Chart installation folder. Find the Spreadsheet you want to recover (they have a file extension of .scss) and copy and paste it into your "Data" folder (also under your main Sierra Chart installation folder). You will then need to change the name, as the backups are tagged with the day of the month at the front. For the most reliable, advanced, and zero cost futures order routing, use 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: