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

B

Barb Reinhardt

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
 
B

Barb Reinhardt

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
 
B

Barb Reinhardt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top