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.