Support Board
Date/Time: Wed, 27 Nov 2024 16:53:38 +0000
Post From: Spreadsheet Losing Formulas
| [2014-09-15 21:06:09] |
| Sawtooth - Posts: 4120 |
|
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. |