The original post has aged off for me, but you could try this:

Select a single cell on the worksheet
edit|Replace
what: = (equal sign)
with: =
replace all

Excel will see that you're changing the formulas and reevaluate them.

If that doesn't help, you may want to post more details.

Patti wrote:

I'm having the same problem. It doesn't update with an F9. Calculation is not
set to manual.

thx,
patti

"GoBobbyGo" wrote:



"Mark" wrote:

Do they update with F9? If so you have changed calculation to manual.

Mark

No, no update with F9 (unless of course the source file is open too, as
previously stated)

--

Dave Peterson