C
cyclop
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.
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.