Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update data wihout opening the file?
Hi,
I hope anyone can give me some advice.. I have file Book3.xls (summary) which linked to Book2.xls (calculation), and Book2.xls is linked to Book1.xls (source data). I often make changes in Book1.xls. Can I get the updated data when I open Book3.xls without having to open Book2 ? Is it possible for Excel to update its data without opening the "calculation" file as stored in Book2.xls? In fact, there are hundreds of Book2.xls for hundreds of different item calculation, they made my head swam everytime I have to re-open them one by one.. Help me please... Thank you so much for everything.. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update data wihout opening the file?
not sure if this is the best way,, but could you not set a on save macro that auto opens and closes book 2 when you save book "Vellarian" wrote: Hi, I hope anyone can give me some advice.. I have file Book3.xls (summary) which linked to Book2.xls (calculation), and Book2.xls is linked to Book1.xls (source data). I often make changes in Book1.xls. Can I get the updated data when I open Book3.xls without having to open Book2 ? Is it possible for Excel to update its data without opening the "calculation" file as stored in Book2.xls? In fact, there are hundreds of Book2.xls for hundreds of different item calculation, they made my head swam everytime I have to re-open them one by one.. Help me please... Thank you so much for everything.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I update an excel file without opening it? | Excel Discussion (Misc queries) | |||
how to update data without opening linked files? | Excel Discussion (Misc queries) | |||
how can update the data in an excel workbook without opening it | Excel Worksheet Functions | |||
Update data without opening file? | Excel Discussion (Misc queries) | |||
automatically update links without opening file | Excel Worksheet Functions |