I have set up excel to import data from an access database - I then need to perform a lookup on this data without the end user actually seeing the table of data. But the only problem is that the data is constantly changing and needing to be refresh - but when you hide the coloums and protect the sheet the data cant be refreshed. Any ideas?