B
big t
Hi everyone,
I have a workbook which contains several user defined functions in Excel 2000. I use the workbook in manual recalculation mode.
The problem is that when I hit F9 it doesn't recalculate the user defined functions, only the Excel ones. At the moment I have to go through all the cells with user defined functions and do F2..Enter. This takes me a long, long, long time.....
Does anyone know of any setting I can use to force Excel to recalculate everything???
TIA,
big t
I have a workbook which contains several user defined functions in Excel 2000. I use the workbook in manual recalculation mode.
The problem is that when I hit F9 it doesn't recalculate the user defined functions, only the Excel ones. At the moment I have to go through all the cells with user defined functions and do F2..Enter. This takes me a long, long, long time.....
Does anyone know of any setting I can use to force Excel to recalculate everything???
TIA,
big t