Thanks Brian for your advice.

I've just looked into the EXCEL linking option and thanks thats interesting to know how to do it after reading.

They ideally wanted me to do a...

I fixed it it was me.

It can use lookups quite happily in the expression,but make sure the values are good ones on your test and i had a...