Formulas inserting from nowhere??

[Ed]

I'm working on a spreadsheet that I got from someone else (who got it
elsewhere originally, so they don't know the answer either). I type a
value in a cell and other cells automatically calculate. No big deal
- except there are no formulas in those cells until I type a value in
the first cell! There are no macros, no formulas in other unused
cells, and no conditional formats that I can find.

How does it do this??!?

Ed

 

[Dave Peterson]

Did you look for event macros under that worksheet?

And you sure that any formulas weren't hidden by format|conditional formatting?

Or even format|cells|protection tab|locked and hidden checked?

 

[Sandy Mann]

Isn't this just the Extend list formats and formulas option?

Tools > Options> Edit > Extend list formats and formulas.


Not that I would know only having XL97 <g>

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Dave Peterson]

Could be. (I've never had any luck with this feature. I don't understand its
rules, so I don't use it!)

Might be Data|List, too?

(Data|List was added in xl2003.)

 

[Ed]

Hi, Sandy.

Isn't this just the Extend list formats and formulas option?

Tools > Options> Edit > Extend list formats and formulas.

Well, that is checked. I never knew that exisited!!

***************************
Extend formats and formulas to additional rows
By default, Microsoft Excel automatically formats new data that you
type at the end of a range to match the preceding rows. Excel also
automatically copies formulas that have been repeated in the preceding
rows and extends them to additional rows.

Note In order to be extended to new rows in the range, the formats
and formulas must appear in at least three of the five preceding
rows.
***************************

That's pretty handy! Can it be workbook-specific, I wonder? Or is
it checked or unchecked for all workbooks in each session?

Ed

 

[Sandy Mann]

That's pretty handy! Can it be workbook-specific, I wonder? Or is
it checked or unchecked for all workbooks in each session?

I think that it is workbook specific but as I said, having only XL97 I don't
have it at all. Perhaps one of out *posh* friends with later versions can
tell us, or you could of course experiment for yourself and then YOU could
tell Us. <g>

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Roger Govier]

Hi Sandy

As far as I can see, it is applicable to the Excel session i.e all
workbooks loaded follow the pattern set under Tools>Options, and like
Calculation mode, the setting on the first workbook opened, sets the
value for that session unless you alter it.

 

[Sandy Mann]

Thank you Roger. I will try to remember that until I manage to upgrade to a
later version - I just hope that my memory is THAT good. <g>

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Roger Govier]

I just hope that my memory is THAT good. <g>

I'm sure it will be - now what was your name?<bg>