Hi Niek,

Thanks for your message. I have tried this but the functionality doesn't
seem to make any difference to the list length of the adjacent formulas.
Perhaps I don't have something set up properly or have missed something

Cheers
James

"Niek Otten" wrote:

Office button (large round, top left), Excel Options, Advanced tab,check Extend Data range formats and formulas

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JamesH81" wrote in message ...
|I am using MS Query to import external data. The number of rows imported
| changes (inceases/decreases) based on user defined criteria. I import into
| columns A-D but have a many columns linking to the data using formulas
|
| In excel 97-2003 there was a useful little piece of functionality that
| allowed you to fill adjacent formulas so as the extrnal data range
| expanded/contracted the adjacent formuals and hence named rnages would also
| do the same.
|
| Does the same functionality exist in Excel 2007. I can't find it anywhere.