#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default links to source

I have several work books link to a master work book I use to update part #,
prices, materials, etc. My question is- is there anyway to add rows or
delete rows in the source work book with out changing the destination data
that is link to the master work book?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default links to source

Linked is linked. Any changes to one cell will be reflected in the linked
cells.
--
HTH...

Jim Thomlinson


"mcfly" wrote:

I have several work books link to a master work book I use to update part #,
prices, materials, etc. My question is- is there anyway to add rows or
delete rows in the source work book with out changing the destination data
that is link to the master work book?

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
Why will links not update unless source is open? WesJFrank Excel Discussion (Misc queries) 4 August 3rd 07 03:14 PM
Changing the source of links. rj Excel Discussion (Misc queries) 0 April 26th 06 03:59 PM
prompt user to change source of links Bobak Excel Discussion (Misc queries) 4 March 20th 06 07:29 PM
** Links don't update UNLESS source file is open Jack Links and Linking in Excel 1 July 27th 05 02:02 PM
** Links don't update UNLESS source file is open Jack Links and Linking in Excel 0 July 14th 05 05:55 PM


All times are GMT +1. The time now is 05:20 AM.

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"