Support Board

Date/Time: Tue, 07 May 2024 01:29:40 +0000

Post From: Technical problem: spreadsheets intermittently stop updating

[2013-09-04 01:48:34] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
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