Excel F9 error

K

KCM Andrea

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.
 
J

Jim Cone

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 [email protected]>
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.
 
J

Jim Cone

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 [email protected]>
wrote in message
I've done that and it still does not correct the error
 
H

Harlan Grove

Harlan Grove said:
...>If you have lots of then this macro will do it for you.

...

Simpler by far just to replace = with = .
Click to expand...

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

Jim Cone

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" <[email protected]>
wrote in message
Harlan Grove said:
...>If you have lots of then this macro will do it for you.

...

Simpler by far just to replace = with = .
Click to expand...

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