On 2/1/2013 7:58 PM, Andrew Douglas Pitonyak wrote:
On 02/01/2013 02:23 PM, David L Babcock wrote:
I have a file for collecting a year's data which I want to duplicate
for the next year (2013).
Since I am annoyed by a bunch of structural/embedded things that are
copied along from year to year when I do a simple rename, I am
building a new file, sheet by sheet, by copying each sheet over to it.
(This scrambles many of the links between sheets, but I can fix these.)
However the graphs so transferred appear in the new file with a data
table instead of actual cell ranges, which kills them dead so far as
showing changing data. They show a snapshot of last year's last data.
I do not want to build anew these graphs, they are complex, with many
attribute tweaks.
Any ideas? XP, OO 3.4
I have no particular comment on your current process, but.... is it
possible for you to create a template from this (even if you only save
a mostly empty copy for next year) so that you can start from the
"mostly empty" stage easily next year.
A template would usually work, but it's this year's special case of
trying to shake out some obscure oddities from the file, that makes a
total new file seem necessary.
In addition I would like in general to be able to copy/paste a complex
graph from one spreadsheet to another.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
