Calculate does not work consistently

G

Guest

Have application.calculate in some code, but it doesn't always run and
end-user has to press F9 to force calculation. I also usually have manual
calculation on in my regular workbooks since they're large and sometimes when
I press F9 it does not perform a calculation.

I searched the database but did not see anything similar to this, so any
ideas would be greatly appreciated.

Thanks!
 
N

Niek Otten

Take a look at Charles William's site:

www.decisionmodels.com


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Have application.calculate in some code, but it doesn't always run and
| end-user has to press F9 to force calculation. I also usually have manual
| calculation on in my regular workbooks since they're large and sometimes when
| I press F9 it does not perform a calculation.
|
| I searched the database but did not see anything similar to this, so any
| ideas would be greatly appreciated.
|
| Thanks!
| --
| Marv Lusk
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Application.Calculate" does not always update/recalculate the for 2
Accuracy of Using Calculate - IMPORTANT QUESTION PLEASE 2
Forcing to recalculate 7
Application.Volatile False doesn't work with Application.Run? 1
How do I calculate at timed intervals? 1
Event Macro Calculate Does Not Work 4
Workbook Open event does not fire 3
Why does 'calculate' show in the status bar, even after i hit F9? 1

Top