R
Reg
I have created some charts and saved them as templates (crtx). I can apply
them to existing chart and, subject to some occasional odd behaviour
(plotting agains the ''wrong' axis) it works ok. Not a huge timesaver but you
take what you can get.
However, if i 'Insert' a new chart using any of three templates I have
created - and then attempt to add data to it the workbook is corrupted when I
try to save and ALL charts and Range names disappear.
I am using the name manager from peltiertech but that has always worked
before and even if i avoid using it the problem recurs.
My questions are:
1.) has anyone else seen/fixed this ?
2.) how 'safe' is my workaround (create a chart first, then apply the
template, then correct the result to match what the template would have done
in the first place)
3.) has anyone else noticed that 2007/2010 Tables and charts seem to be a)
flaky and b) slow and c) not all that well integrated with the 'rest' of
excel?
them to existing chart and, subject to some occasional odd behaviour
(plotting agains the ''wrong' axis) it works ok. Not a huge timesaver but you
take what you can get.
However, if i 'Insert' a new chart using any of three templates I have
created - and then attempt to add data to it the workbook is corrupted when I
try to save and ALL charts and Range names disappear.
I am using the name manager from peltiertech but that has always worked
before and even if i avoid using it the problem recurs.
My questions are:
1.) has anyone else seen/fixed this ?
2.) how 'safe' is my workaround (create a chart first, then apply the
template, then correct the result to match what the template would have done
in the first place)
3.) has anyone else noticed that 2007/2010 Tables and charts seem to be a)
flaky and b) slow and c) not all that well integrated with the 'rest' of
excel?