I'm working with a new spreadsheet project in my company and am having an
issue. When I press F9 to update the formulas, it replaces every single
formula cell with #NAME?. What is the issue and how do I fix it.

Go to the Tools menu and select Add-ins.
In the displayed list Checkmark "Analysis ToolPak"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"KCM Andrea" <KCM
wrote in message
I'm working with a new spreadsheet project in my company and am having an
issue. When I press F9 to update the formulas, it replaces every single
formula cell with #NAME?. What is the issue and how do I fix it.

I've done that and it still does not correct the error

"Jim Cone" wrote:


Go to the Tools menu and select Add-ins.
In the displayed list Checkmark "Analysis ToolPak"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"KCM Andrea" <KCM
wrote in message
I'm working with a new spreadsheet project in my company and am having an
issue. When I press F9 to update the formulas, it replaces every single
formula cell with #NAME?. What is the issue and how do I fix it.

The formulas all have to be recalculated.
Select a problem cell, press F2 and Enter.
If that works, repeat for all #Name cells.
If you have lots of then this macro will do it for you.
Select cells before running it...
'----
Sub MakeThemWork()
Dim rcell As Range
For Each rcell In Selection.Cells
rcell.Formula = rcell.Formula
Next
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"KCM Andrea"
<KCM
wrote in message
I've done that and it still does not correct the error



"Jim Cone" wrote:

Go to the Tools menu and select Add-ins.
In the displayed list Checkmark "Analysis ToolPak"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"KCM Andrea" <KCM
wrote in message
I'm working with a new spreadsheet project in my company and am having an
issue. When I press F9 to update the formulas, it replaces every single
formula cell with #NAME?. What is the issue and how do I fix it.

"Jim Cone" wrote...
....
If you have lots of then this macro will do it for you.
....

Simpler by far just to replace = with = .

Harlan Grove wrote...
"Jim Cone" wrote...

...If you have lots of then this macro will do it for you.

...

Simpler by far just to replace = with = .

Even simpler, [Ctrl]+[Alt]+[F9] (full recalc) should work.

Harlan,
I've never gotten the ctrl + Alt + F9 to work for me in
that situation.
Replacing the equal sign sounds like the way to go, especially
when the response to running a macro is likely to be "what's that?"
Jim Cone


"Harlan Grove"
wrote in message
Harlan Grove wrote...
"Jim Cone" wrote...

...If you have lots of then this macro will do it for you.

...

Simpler by far just to replace = with = .

Even simpler, [Ctrl]+[Alt]+[F9] (full recalc) should work.