Hi all, I have a workbook (mainWB) that get information from many different workbooks (underWBs) there is no problem updating this information. The UnderWBs also has references to external data (HTML) if I open an UnderWB and update information there is also no problem. Remember there are multiple UnderWBs The Problem; Is it possible to open the mainWB Update all the information from HTML to UnderWBs to MainWB (without having to open all the different UnderWBs?) Thanks in advance. 
