Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
General: Why will links created between two Excel spreadsheets NOT update
properly when the target Excel file is embedded in a PowerPoint chart/file? I created the original set of files on my desktop and then uploaded to a SharePoint site? Specifics: I linked cells between an Excel source file and an Excel target file. I then embedded the target file in a PowerPoint file/chart. As expected, when I change data in the source file, the changes are linked into the target file that exists in the PowerPoint file. Works great! But I really want to place all three files together in a SharePoint site. When I change source data in the SharePoint Excel file, the target file still updates OK; the linkage was preserved when I uploaded the two Excel files. However, the target Excel file embedded in PowerPoint does not update. I looked at the linked cell in the embedded Excel file; it is still pointing back to the original target file on the Desktop. Guess this makes sense if uploading a PowerPoint file from Desktop into SharePoint does not preserved embedded Excel links. So what do I do? Is it necessary to create all the linkages from within SharePoint? Can I safely move the files back and forth between SharePoint and Desktop (or anywhere on the PC) in a way that the linked cells are updated as desired? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
hummm - no response. Have I asked a question for SharePoint, instead of Excel?
"luddite" wrote: General: Why will links created between two Excel spreadsheets NOT update properly when the target Excel file is embedded in a PowerPoint chart/file? I created the original set of files on my desktop and then uploaded to a SharePoint site? Specifics: I linked cells between an Excel source file and an Excel target file. I then embedded the target file in a PowerPoint file/chart. As expected, when I change data in the source file, the changes are linked into the target file that exists in the PowerPoint file. Works great! But I really want to place all three files together in a SharePoint site. When I change source data in the SharePoint Excel file, the target file still updates OK; the linkage was preserved when I uploaded the two Excel files. However, the target Excel file embedded in PowerPoint does not update. I looked at the linked cell in the embedded Excel file; it is still pointing back to the original target file on the Desktop. Guess this makes sense if uploading a PowerPoint file from Desktop into SharePoint does not preserved embedded Excel links. So what do I do? Is it necessary to create all the linkages from within SharePoint? Can I safely move the files back and forth between SharePoint and Desktop (or anywhere on the PC) in a way that the linked cells are updated as desired? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
links to a powerpoint file in excel | Excel Discussion (Misc queries) | |||
Excel - PowerPoint links | Excel Discussion (Misc queries) | |||
excel to powerpoint | Excel Worksheet Functions | |||
EXCEL AND POWERPOINT | New Users to Excel | |||
excel, powerpoint | Excel Discussion (Misc queries) |