Thanks, but

F9 did not work
ctrl+alt+F9 (and all permutations of ctrl/alt/shift with F9) did not work
The macro solution also did not work

:scratching head:

--
//Jason


"excelent" wrote:

or maby:
Sub reCalc()
Application.CalculateFullRebuild
End Sub


"excelent" skrev:

try ctrl+alt+F9


"Jason" skrev:

Funny - I was coming to the forums to search for a solution to this as well.
I can select the cell...and hit F2 and everything updates. My boss actually
asked the same question because he just noticed the same issue on one of his
spreadsheets (he asked me because I am the "office guru" *snort*)...so now I
am here.

For the record....Excel 2003 (company will upgrade to 2007 when it "goes on
sale, I guess)...Win XP.

Calculation is set for "Automatic"

F9 or selection of "Calc Now" or "Calc Sheet" (under the
Options...Calculation menu) does not solve it.

Anyone? Beuller?

"JoJo" wrote:

Folks:



In my spreadsheet, I have a section in which imported data from a text file
is located. The other section of my spreadsheet (containing the necessary
formulae)
is devoted to running calculations on the newly imported data. It looks like
the calculations do not completely & automatically take place after the
fresh data
from the text file is imported.

So I have to manually copy & paste the formulae throughout the calculation
section once again. At this point I get to my final destination of nice
clean fresh calculations.
I was hoping to solve this problem by hitting the "Refresh Current Page"
button; but looks like this simply loads the file all over again.

* Is there a way to get my spreadsheet to re-run the calculations
immediately after I re-load fresh data ?



Thanks,
John.