Reevaluate formula/function in cell

[p0]

Hello,

Is there a way to redo all calculations in a worksheet in Excel 2007?

The worksheet I have has a small VBA function which gets the
filelength of some files on my machine:

Function Length(location As String)
Length = FileLen(location)
End Function

Some of the files get updated, so I wish to reevaluate the cells
calling the function. F9 (or shift+F9) does not work in this case. It
is as if Excel sees that the input parameters of the function have not
changed and therefore the function does not require reevaluation.

TIA,

Yves

 

[Wigi]

Hi

You could perhaps use:

=Length("some location")+A1

then, change A1 to recalculate.