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.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info: http://www.pitonyak.org/oo.php
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
