View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Excel/ PPT linking question

Hi,

See comments in-line

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Alex" wrote:

Went on pptfaq.com and learnt of linking and became addicted to it in the
past week. I'm doing some testing now to see if it could applied at my
office. couple questions wanted to bounce off ideas from you experts:

- renaming issues. what is the impact of renaming files to the links?
(excel/ ppt or both) how should we safeguard links if renaming is required?
(any solutions)



When the source file name is changed while the target is closed you will
need to open the target file and choose the Edit, Links, Change Source.


- what's the best way to break links... and send to eg. external client? i
noticed if the excel is not around it will prompt reader it update links...
anyways to eliminate that?


To break links choose Edit, Links, Break Link


- impact of save as... copy & paste vs cut & paste? any insights on the
impact to links on these operations? did some testing myself... got
confused..myself


Not sure what you mean - but Save As in the target file has no effect on the
link, of course in the source file was what the previous questions applied
to. The question of copy and paste depends on how you copy and how you
paste.


Thanks!