We have five or six workbooks that are linked together to perform vlookups etc. The down side is that if anything changes you have to manually refresh the links to view the updated information. I'm debating about converting the links to data connections and performing the vlookups on the table created from the connection (vlookup would now be in the active workbook). We could then set the connection to auto refresh periodically.
I'm wondering what the pros and cons are between using the data connection vs linking the workbook workbook. Can anyone offer some insight?
I'm wondering what the pros and cons are between using the data connection vs linking the workbook workbook. Can anyone offer some insight?
