Strange problem when running macro from PPT'07 copying ranges from
 

I am copying charts and cell ranges from excel to PPT2007 and I get the
following error

A formula in this worksheet contains one or more invalid references.
Verify that your formulas contain a valid path, workbook, range name, and
cell reference.

In any case it causes the code to stop functioning because the error it
displayed. I'm not sure where the error might be. Can someone direct me to
where to look. I've looked at the named ranges and have pulled out all of
the ranges that have lost their refers to range info at some point. (did
that long ago). I'm not sure where to look.

Thanks,
Barb Reinhardt

Strange problem when running macro from PPT'07 copying ranges from
 

FWIW, there is a chart on the affected worksheet where all of the data for
every Series is NA(). I know to look in the named ranges, the chart series
and the formulas. Any other options?
Thanks,
Barb Reinhardt




"Barb Reinhardt" wrote:

I am copying charts and cell ranges from excel to PPT2007 and I get the
following error

A formula in this worksheet contains one or more invalid references.
Verify that your formulas contain a valid path, workbook, range name, and
cell reference.

In any case it causes the code to stop functioning because the error it
displayed. I'm not sure where the error might be. Can someone direct me to
where to look. I've looked at the named ranges and have pulled out all of
the ranges that have lost their refers to range info at some point. (did
that long ago). I'm not sure where to look.

Thanks,
Barb Reinhardt

Strange problem when running macro from PPT'07 copying ranges from
 

I've also found this KB Article, and if this is true, I'm really not sure how
I'm going to get around the error without using Application.Displayalerts =
FALSE and I don't want to do that unless I know what alert I may be disabling.

http://support.microsoft.com/kb/931389

Thanks,
Barb Reinhardt




"Barb Reinhardt" wrote:

I am copying charts and cell ranges from excel to PPT2007 and I get the
following error

A formula in this worksheet contains one or more invalid references.
Verify that your formulas contain a valid path, workbook, range name, and
cell reference.

In any case it causes the code to stop functioning because the error it
displayed. I'm not sure where the error might be. Can someone direct me to
where to look. I've looked at the named ranges and have pulled out all of
the ranges that have lost their refers to range info at some point. (did
that long ago). I'm not sure where to look.

Thanks,
Barb Reinhardt