Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a spreadsheet w/ multiple worksheets/tabs (3 for right now). I also
have a PowerPoint file w/ the 3 slides (one for each worksheet/tab). On my 1st tab I have a small matrix that is basis for a graph. Both, matrix and graph have an active link to my 1st PPT slide. When I make a change in Excel and open PPT, the changes are updated in PPT... so far so good. Now, back in Excel, I copied the 1st worksheet twice and entered only different numbers into the matrix... which update my two Excel graphs properly... still, so far so good. In PPT, I added now 2 additional slides that need to be linked to the 2nd and 3rd tab. Unfortunately, I'm not very successful w/ updating the link from Slide2 to Worksheet2 & Slide3 to Worksheet3. Each time I select "Linked Worksheet Object" and Then "Edit", either of the 2 links refer back to the 1st tab. How can I update my link from e.g. slide 2 to worksheet 2? If prefer to not recreate the objects in PPT since I then have to fiddle around w/ finding out the identical alignment (horizontal and vertical) plus height/width... I'm sure there's a quick trick? Anyone an idea? Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I grab graph coordinates in Excel via the mouse with VB? | Charts and Charting in Excel | |||
Need to get slope of peaks on excel graph | Charts and Charting in Excel | |||
Multi-Page Word Doc Linked to Excel? | Excel Discussion (Misc queries) | |||
How do I create a Bell Curve Graph in Excel | Charts and Charting in Excel | |||
How do I graph a quarterly time-series in Excel? | Charts and Charting in Excel |