How It Works
Link the workbooks once, then update many times
|Link Workbooks Once
|Update Many Times
Name ranges/tables starting with a "Item Name Prefix" that you want to export.
click "Submit Content"
Name ranges/tables starting with an "Item Prefix (Destination)". For example, the prefix could be "in_", but it could be the same as the source prefix.
The item's name should match a source item's name. For example, r_ItemName (source) will update in_ItemName (destination).
Use "List Items" to view which ranges/names are matched to source items and to help add items that are not yet added.
"List Items" to list which ranges/tables will be updated
"Update Excel" to update all matching items (where destination item name matches source item name)
Please Note: Excel-to-Excel updates values only (not formulas or formats)
Excel-to-Excel does not update formulas: the location of dependent cells can change from source to destination. For example, if user inserts a row in one of the files. Another example: the source range may contain a formula referring to a cell on another sheet that may not exist in the destination file. There's no way the add-in can determine the desired target cell location in the destination workbook. That is why the add-in only updates values. The add-in also allows you to optionally skip updating cells that contain formulas (that may already refer to desired cells in the destination file).
Excel-to-Excel does not update formats: You must format your destination range/table as desired. An advantage of tables is that table styles are applied when you re-size tables. If ranges are re-sized, formats will not follow.