P
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
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