External data ranges: Keeping information aligned

I have a list of names that I've imported into Excel from Access DB. However, when the data range expands (or contracts), information filled in (ie Date) for a specific person does not remain next to their name. For example, Mr. Smith on row 6 moves to row 7 when a new name is added, but any information filled in for him remains on row 6. I've tried to follow the instruction under "copy formulas when an external data range expands", but I guess I'm missing something because it doesn't work.