copying formulas

[Jan]

In previous versions of Excel in a basic spreadsheet I
could type a simple formula into a cell, drag it across
with the handle, and it would extend the formula and fill
in the result (for each column). In Excel 2003 the
formula is copied but not updated for each new column.
Other than double-clicking on each individual cell to
update to the correct range, is there a way to do this
easily?

 

[Peo Sjoblom]

There is no difference in this regard, you probably opened a wb with
calculation set to manual and now
all other wbs act the same way, do tools>options>calculations and check
automatic

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom