| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing Data in Closed Workbooks | Excel Discussion (Misc queries) | |||
| Copying From Closed Workbooks | Excel Worksheet Functions | |||
| Keeping data once referenced workbooks are closed. | Excel Discussion (Misc queries) | |||
| SAVING DATA TO CLOSED WORKBOOKS | Excel Worksheet Functions | |||
| Data from closed workbooks (pull func, indirect.ext, etc ....) | Excel Worksheet Functions | |||
Hybrid Mode
