Hi,
I'm hoping you can help with these issues.
1.
I have a workbook where I import data from other workbooks into various hidden sheets.
I then have one master sheet that links them all together using vlookup.
My problem is when I import the workbooks my Vlookup formula change the look up range.
2.
I am getting a privacy warning.
"This document contains macros, ActiveX Controls, XML expansion pack information or Web components."
I checked the Macro settings but it is all greyed out.
Thanks in Advance
I'm hoping you can help with these issues.
1.
I have a workbook where I import data from other workbooks into various hidden sheets.
I then have one master sheet that links them all together using vlookup.
My problem is when I import the workbooks my Vlookup formula change the look up range.
2.
I am getting a privacy warning.
"This document contains macros, ActiveX Controls, XML expansion pack information or Web components."
I checked the Macro settings but it is all greyed out.
Thanks in Advance