In excel 2007 I can't find the fill adjacent formulas function

  • Thread starter Thread starter JamesH81
  • Start date Start date
J

JamesH81

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.
 
JNW,

Thanks for your response. I've taken a look at the flash help and it doesn't
allow you to get to the tick box to select fill adjacent formuals in 2003.
Thus, it won't show me where it is in 2007.
 
Office button (large round, top left), Excel Options, Advanced tab,check Extend Data range formats and formulas

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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.
 
You can find the External Data Range Properties dialog under Data|
Connections|Properties.

Cloiff Edwards
 
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
 
Back
Top