Support Board
Date/Time: Sun, 24 Nov 2024 05:46:05 +0000
Post From: Technical problem: spreadsheets intermittently stop updating
| [2013-09-04 01:48:34] |
| Sawtooth - Posts: 4118 |
|
The way to change the chart number of a chart is to repeatedly duplicate the chart until a duplicate is the desired number, then delete all of the unneeded ones. But there are other better solutions: -You can set the Formula Source Sheet Number to the sheet where the formulas are. However, if your formulas reference any column H or J cells, you'll have to manually copy/paste them. -If you have no other spreadsheet studies on any chart in the chartbook, you can safely set the Chart Data Output Sheet Number to the sheet with the formulas. Confirm that the Formula Source Sheet Number is the same. -You can manually copy/paste all of the formulas. Date Time Of Last Edit: 2013-09-04 04:51:37
|