Support Board
Date/Time: Wed, 27 Nov 2024 16:59:00 +0000
Post From: Duplicating Chart with spreadsheet attached
| [2014-09-14 19:13:22] |
| Sawtooth - Posts: 4120 |
|
If you are using the duplicated chart and duplicated spreadsheet in the same chartbook, you don't need to rename it. It will add a new Sheet# corresponding to the duplicated chart#, and the Formula Source Sheet Number will be the same as the original spreadsheet. If you don't want to use the original sheet's formulas in the duplicated sheet, you need to change the Formula Source Sheet Number to match the new Sheet#. If you duplicate the chart/spreadsheet to another chartbook, you'll want to rename the spreadsheet file if you are going to have both chartbooks open concurrently. If the destination chartbook already has a chart# that is the same as the source chart#, you also might need to edit the Formula Source Sheet Number. |