Linking Excel

  • Thread starter Thread starter Juan
  • Start date Start date
J

Juan

I have Powerpoint 2000 and Excel 2000 (I also have a
machine with Excel XP). On a presentation, I have linked
graphs that come from a single excel workbook, but from
different pages. Each of the graphs is based on data on
one of the workbook pages.

When I open Powerpoint, it asks me if I want to update the
links, and I need to answer ok, but then an excel message
comes up saying: "This workbook contains links to other
data sources", and asks if I want to update. This happens
again and again for each page where a graph is located, so
I have to answer the same question several times, not
counting the original "update" question that I answered
Yes. Is there any way to work this or do I need to
completely break out the excel workbook into individual
files to avoid this from happening. Thanks for your
assistance.
 
I think you would need to break out the Excel workbook to prevent this,
Juan. As PPT updates its charts from Excel, Excel is checking for
updatated data (which those charts are in turn linked to). So you've got
kind of a daisy-chain effect happening. I'm sure you can tell what's
going on, since you're thinking about breaking out the workbook in the
first place.

I would imagine, though, that there's a way in Excel to lock the links
or prevent them from updating somehow. Hopefully Brian Reilly (our
resident PPT-Excel guru) or one of the Excel MVPs who pop in from time
to time will see this and toss in their thoughts.
 
Thanks for the assistance. I tried the add-in already and
does not solve my problem. Hope anyone else may have a
better answer. My excel spreadsheets were already done
and there are several that I would need to break in pieces
to make this work. Thanks again,
 
Back
Top