ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calculate does not work consistently (https://www.excelbanter.com/excel-programming/374394-calculate-does-not-work-consistently.html)

MarvInBoise

Calculate does not work consistently
 
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


Niek Otten

Calculate does not work consistently
 
Take a look at Charles William's site:

www.decisionmodels.com


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"MarvInBoise" wrote in message ...
| 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
|




All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com