Refreshing external data and retain manually enterd data that pertains to existing external data.

[Samoht_lee]

Hi All,

I am stumped on an issue with my Excel worksheet. I have a list of Names from an external datasource and it's refreshed occasionally. Next to the list of names are a few cells which contains values about the names. The problem that I'm facing is that when I refresh the external data, the cells which where manually entered next to the names don't shift along with the appropriate names. I've tried to setting the properties on the Data tab but I don't think that this works for data that are not part of the external datasource. Is there any other option that Excel has for this to work?

Thanks in advance