#1
|
|||
|
|||
Linked Tables
I'm having an issue with linked tables. I don't have them linked in the traditional way. I need the data from several other sources, but the issue is the excel files that house the data are not being edited, they are being overwritten every time. Therefore, I can't edit those files to help myself out.
Another issue is that I don't want the exact numbers in a table. I want to be able to pull data from an excel spreadsheet and do further calculations directly in powerpoint. Here is what I've done: 1) Created an excel spreadsheet in powerpoint. 2) Copied a cell from the excel file and pasted it as a link in the PPT table 3) The link manifests itself as a formula, ='filepath[source.xls]info'!B2 4) I manipulate the data so I can get it in the right format ex: =TEXT('filepath[source.xls]info'!B2,"0.00") 5) I close the excel spread sheet and the PPT 6) I open the excel spread sheet and edit the data, save, close 7) I open the PPT and the data does NOT UPDATE Not only does the data not update, but I can't even manage it as a link. Apparently the link was broken when I tried to manipulate it. The only way I can get the data to update in ppt is to open the table, open the cell, and hit "enter" to re-execute the formula. I can't even open the table and do a "Calculate the entire spreadsheet". I have to manually execute every cell. I'm guessing I break the links when I add forumlas to the tables. Now I don't have links I only have references that won't update automatically and can't be managed. How can I make these references automatically update? Is it possible to manipulate linked data in the destination table and mantain the link? As a work around, is there a simple macro I can make it ppt that will search for every excel spreadsheet on the slide and recalculate every cell? Any ideas or suggestions? NOTE: If I have the excel spreadsheet OPEN all I have to do is double click the table and every cell in the PPT updates. If the excel spreadsheet is CLOSED I have to manually execute the formula for every cell in the PPT. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
listing linked graphics | eng1ne | Drawing and Graphics | 5 | 02-28-2012 06:42 AM |
Can Tables or Information be Linked in Word? | ddrowe | Word | 1 | 11-18-2011 11:50 AM |
making 2 files that are linked. | glda19 | Word | 1 | 04-05-2011 03:46 PM |
Track changes and linked tables in 2010 | sheree | Word | 2 | 02-04-2011 06:37 AM |
Linked Videos in Word to run off of CD Rom | jycomer | Word | 0 | 12-14-2010 03:16 PM |