Support Board

Date/Time: Sat, 18 May 2024 05:11:57 +0000

Post From: Problem with Duplicating Chartbooks with Alert Speadsheets

[2015-06-24 01:53:29] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4000
If you duplicate into the same chartbook, the formulas will not copy to the new sheet#. This cannot be true. And we did a test to verify that the formulas do copy. If I duplicate chart #1 into the same chartbook, and no chart #2 exists, the duplicate chart will be #2, the new sheet will be #2, and the Formula Source Sheet Number will also be 2. There will be no formulas on Sheet #2. This scenario assumes the Chart Data Output Sheet Number is 0. This is not a problem for me, so no need to change it on my account. Some time back, maybe some years ago, a duplicated chart would keep the original Formula Source Sheet Number. I personally like it the way it is now. And it's not difficult to copy/paste formulas, which I have to do anyway if column H or J is involved. Date Time Of Last Edit: 2015-06-24 02:45:05