Hi Everyone,
I have been searching all the different forums for a solution and I haven't found one that works. I am using multiple COUNTIF / SUMIF functions in my spreadsheet for different calculations and the data is sourced in a second workbook. I know when the source workbook is closed, you will receive the #value error in the destination workbook. However I am trying to share my destination workbook with colleagues that cannot have access to some of the information in the source workbook, so I am looking for VBA code that will open the source workbook to update the links and then close. Is this possible?
I have been searching all the different forums for a solution and I haven't found one that works. I am using multiple COUNTIF / SUMIF functions in my spreadsheet for different calculations and the data is sourced in a second workbook. I know when the source workbook is closed, you will receive the #value error in the destination workbook. However I am trying to share my destination workbook with colleagues that cannot have access to some of the information in the source workbook, so I am looking for VBA code that will open the source workbook to update the links and then close. Is this possible?
