Posted to microsoft.public.excel.programming

external usenet poster

Posts: 40

Prolem with recalculation

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Recalculation	Lpoffe	Excel Worksheet Functions	0	October 2nd 09 06:06 PM
Recalculation?	Mike D.	Excel Discussion (Misc queries)	8	July 13th 07 04:33 AM
Recalculation	workerboy	Excel Worksheet Functions	3	May 15th 06 06:14 PM
Recalculation	R Ormerod	Excel Discussion (Misc queries)	5	March 19th 06 08:54 AM
Too much recalculation	Diane Meade[_2_]	Excel Programming	2	May 26th 04 07:19 PM

All times are GMT +1. The time now is 04:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us