When you import the data, do you copy it over what might be there
already? It might be better to clear all the data first and then import
- your formula for Extension can then be copied down for as many rows
as you have in this latest import without giving rise to the #REF
error.

Hope this helps.

Pete