I know this is frustrating. It hardly makes sense to ask why, because the
answer will be along the lines of "because". I think it's probably an
oversight. I don't know of a way to change the charts if they are already in
2007, but I'm thinking that it might not hurt to try writing a little
macro.... Maybe if you check my blog in a few days.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Barb Reinhardt" wrote in message
...
I have a workbook that has range names starting with Chart and other range
names that are offset from that one. I'm thinking at least 100 are
affected. I know I can write a macro to change the names, and the series
that use them, but why can't they start with Chart in Office 2007? This
is
going to be a lot of work to update.
Thanks,
Barb Reinhardt