I have a worksheet that pulls data (using external data) from a SQL database. In the same worksheet I have a sheet that pull data from a Access database. The SQL sheet has confidential info on it that I want to be able to hide the data or sheet from anyone being able to see it. On the Access sheet I have a Vlookup that is pull info from the sheet I want hidden, but when I hide and protect it won't let me refresh all because it say the data is Read Only. Is there anyway to get the results I want.