Thank you Peo,

F9 works, SHIFT + F9 works but CTRL + ALT + F9 still doesn't do anything. I
am using XL 97 on Windows XP Home on a Samsung laptop. Perhaps the fact
that it is a laptop that is making the difference because if it works in 95
I would definitely expect it to work in 97. Another thought that just
occurred to me was perhaps I need to reinstall XL.

--
Regards

Sandy

with @tiscali.co.uk


"Peo Sjoblom" wrote in message
...
Here's from Excel 2003 help

Press F9 Calculates formulas that have changed since the last calculation,
and
formulas dependent on them, in all open workbooks. If a workbook is set
for
automatic calculation, you do not need to press F9 for calculation.

Press SHIFT+F9 Calculates formulas that have changed since the last
calculation,
and formulas dependent on them, in the active worksheet.

Press CTRL+ALT+F9 Calculates all formulas in all open workbooks,
regardless
of whether they have changed since last time or not.

Press CTRL+SHIFT+ALT+F9 Rechecks dependent formulas, and then calculates
all
formulas in all open workbooks, regardless of whether they have changed
since
last time or not.

I don't have 97 but I have 95 and Ctrl + Alt + F9 does the same as in 2003
so I am sure it's the same
in 97. I believe number 4 is the one that has been added

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"Sandy Mann" wrote in message
...
Chip,

switch to sheet3, select cell G10, and then CTRL+ALT+F9 to do a full
recalc

In my XL 97, CTRL+ALT+F9 does nothing that I can see but simply pressing
F9 forces a recalculation.

Is it different for later versions?

--
Regards

Sandy

with @tiscali.co.uk


"Chip Pearson" wrote in message
...
This formula will return the address of the same cell that this formula
is
in.....

=CELL("address")

NO, NO, NO.

It will return the address of the Active Cell when a calculation occurs.
To illustrate, put =CELL("address") in Sheet1!A1. Then switch to
sheet3, select cell G10, and then CTRL+ALT+F9 to do a full recalc.
Examine the contents of Sheet1!A1. It is not its own address; it is the
address of Sheet3!G10.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"CLR" wrote in message
...
This formula will return the address of the same cell that this formula
is
in.....

=CELL("address")

Vaya con Dios,
Chuck, CABGx3



"Creator" wrote:

Ok, thanks again for indulging but I don't want any reference in the
formula
to the current cell address, whether by name or otherwise. I want to
use this
formula over many ranges. Is this possible? It's kinda like the cell
asking
itself "=who am I?"
--
Creator


"CLR" wrote:

Yes, if you first give A1 a RangeName.........Insert Name
Define.....type
in say, MyCell......

then this formula, anywhere, will return $A$1.........

=CELL("address",MyCell)

Vaya con Dios,
Chuck, CABGx3





"Creator" wrote:

Thanks for your response.

Can it be done without A1 appearing in the formula?
--
Creator


"CLR" wrote:

=CELL("address",A1)

Vaya con Dios,
Chuck, CABGx3


"Creator" wrote:

Hi, is there a formula that would have as it's output the cell
address of the
same cell where the formula has been entered.

e.g. In cell A10 I input a formula whose output is the cell
reference A10.

I'm hoping that this should be simple.

--
Creator