Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Links won't update if file is closed

Read all these posts but none seems to address this. I've got a file "A"
that has an input table and an outputs table. I change the input values,
which then go out to file "B" where a model calculates an answer and sends
the output back to file "A" outputs table.

Everything works fine if both files are open. I can also change inputs in
"A" and close it. Then open "B" which updates, then close it. Then open "A"
and the outputs update. But I'd like to be able to do this without ever
opening file "B". Reason being that there are actually 40 different file
"B"s and each is 3megs, so it is very inconvenient for someone to open all
of them. The whole point of file "A" is so that someone can use one simple
interface to change inputs and see what the outputs are.

I thought the issue was that the files were not updating "automatically,"
but I've put the files in the same folder and identified that the folder is
"trusted." Unfortunately that didn't take care of the problem.

Much appreciated if anyone has a solution.

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
Saving a file that you do not want to update the links to other fi Derric New Users to Excel 1 July 10th 08 04:56 AM
How do I update links from a file that hasn't yet been updated? RichardsDM Excel Worksheet Functions 0 September 22nd 06 02:28 PM
How to update destination file with source files closed? Alex Costache Excel Discussion (Misc queries) 2 August 1st 06 10:08 AM
update a closed file via links Rob Robbins Excel Discussion (Misc queries) 2 July 13th 05 09:25 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 06:07 AM.

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"