Support Board

Date/Time: Fri, 20 Sep 2024 06:23:55 +0000

Post From: Spreadsheet Losing Formulas

[2014-09-15 21:06:09] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4091
If you manually add a sheet to a spreadsheet study's spreadsheet, and then you add a spreadsheet study to a chart# that corresponds to the manually added sheet#, the formulas on the manually added sheet will disappear. By default the Formula Source Sheet Number matches the Sheet# (tab position from the left) and the Chart#. If you need a calculation sheet, you can use a standalone spreadsheet: File >> New Spreadsheet Then reference the spreadsheet study's sheets. Or manually add a sheet to the spreadsheet study's spreadsheet that has a tab position beyond any potential chart# in your chartbook. I recommend the former, but it will only work in the Old Spreadsheets versions.