Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Links between Excel, and Excel within PowerPoint

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Links between Excel, and Excel within PowerPoint

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
links to a powerpoint file in excel Jim in Florida Excel Discussion (Misc queries) 1 March 23rd 07 10:40 PM
Excel - PowerPoint links [email protected] Excel Discussion (Misc queries) 3 February 22nd 06 01:21 PM
excel to powerpoint confused Excel Worksheet Functions 1 October 5th 05 05:40 PM
EXCEL AND POWERPOINT CANDELYN. CARPENTER New Users to Excel 2 May 12th 05 01:10 PM
excel, powerpoint srm Excel Discussion (Misc queries) 1 January 16th 05 03:40 AM


All times are GMT +1. The time now is 06:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"