Getting Data from Closed Workbooks
 

I have formulas that link to other workbooks, which works fine when
they are open.
But if they are closed it says #VALUE! ... as soon as i open the file
it updates.
Is there anyway i can get this to update without opening the file, to
prevent me having to open the files that they are referring to every
time??
Thanks if you can help.

Getting Data from Closed Workbooks
 

Go to Edit | Links | click update values .....





On Apr 1, 8:42*pm, NPell wrote:
I have formulas that link to other workbooks, which works fine when
they are open.
But if they are closed it says #VALUE! ... as soon as i open the file
it updates.
Is there anyway i can get this to update without opening the file, to
prevent me having to open the files that they are referring to every
time??
Thanks if you can help.

Getting Data from Closed Workbooks
 

maybe...

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

Each recipient would have to make this same change.

NPell wrote:

I have formulas that link to other workbooks, which works fine when
they are open.
But if they are closed it says #VALUE! ... as soon as i open the file
it updates.
Is there anyway i can get this to update without opening the file, to
prevent me having to open the files that they are referring to every
time??
Thanks if you can help.

--

Dave Peterson

Getting Data from Closed Workbooks
 

On Apr 1, 9:11*pm, Dave Peterson wrote:
maybe...

Jim Rech posted a registry tweak:http://groups.google.com/groups?thre...4%40TK2MSFTNGP...

Each recipient would have to make this same change.

NPell wrote:

I have formulas that link to other workbooks, which works fine when
they are open.
But if they are closed it says #VALUE! ... as soon as i open the file
it updates.
Is there anyway i can get this to update without opening the file, to
prevent me having to open the files that they are referring to every
time??
Thanks if you can help.

--

Dave Peterson

Update links doesnt actually work, which i find bizzarre.
Also a registry tweak isnt viable at the moment im afraid, its at work
on the system with shared computers, unfortunately.

Thanks for looking though, maybe i can this Update Links thing to
work. Either that or i will just have to accept that i need to open
all the files??