Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Rob Robbins
 
Posts: n/a
Default update a closed file via links

Can I update a value (linked) in a closed file? In other words, if files A &
B link to data in file C, and I update values in C, is there a function or
program that I can run to force the updates in A & B, without actually
opening A & B?

Thanks,

RR

  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Not that I know of.

But the next time you open them, if you answer the prompts nicely, won't the
values be updated?

Rob Robbins wrote:

Can I update a value (linked) in a closed file? In other words, if files A &
B link to data in file C, and I update values in C, is there a function or
program that I can run to force the updates in A & B, without actually
opening A & B?

Thanks,

RR


--

Dave Peterson
  #3   Report Post  
Rob Robbins
 
Posts: n/a
Default

thanks for your response; yes they would be updated at the next open, but I
wanted to not have to open them (just re-post / attach)


"Dave Peterson" wrote:

Not that I know of.

But the next time you open them, if you answer the prompts nicely, won't the
values be updated?

Rob Robbins wrote:

Can I update a value (linked) in a closed file? In other words, if files A &
B link to data in file C, and I update values in C, is there a function or
program that I can run to force the updates in A & B, without actually
opening A & B?

Thanks,

RR


--

Dave Peterson

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
Edit Links: make update manual Chrissorr Excel Discussion (Misc queries) 5 May 11th 05 11:57 PM
can't update links...can't find links GJR3599 Excel Discussion (Misc queries) 1 April 4th 05 04:56 PM
Update Individual Links mikxtr Excel Discussion (Misc queries) 3 January 21st 05 04:24 AM
File asks to update when no links were created Dave Links and Linking in Excel 1 December 16th 04 08:10 PM
Automatic update of links in destination file when source file mo. Brucgil Excel Discussion (Misc queries) 0 December 2nd 04 04:07 PM


All times are GMT +1. The time now is 11:23 PM.

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

About Us

"It's about Microsoft Excel"