Thanks for the reply,
Its the amount of data that its pulling through. 1 table alone has 333,000 records. i am linked to 6 tables which i need to reresh the data over night.
Basicaly i need a spread sheet that takes
Fields A, B and F from Table 1
A, G, H, J and X From Table 2
J, L, M, N frm...