Hi Alex,

You could try to rebuild the dependency tree with CTRL+ALT+SHIFT+F9.

For lots of information about calculations in Excel, visit Charles William's site:


www.decisionmodels.com

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Alex St-Pierre" wrote in message
...
| Hi!
| Are you using "application.volatile = false"?
| I don't know this function
| Does the status bar say "Calculate" even after you do a manual
| calculation?
| It takes 3 seconds to calculate as when I do an "Application.Calculate".
| When this is done, the status bar indicate doesn't indicate calculate..
| Sometimes, I do a F9 and even after the calculation, the results have changed
| but the data is not correct. Then, if I go in the cell that make the
| "=average(C2:M1000)" and edit the function, the value is changing when I
| press Enter.. This happens not often but should not happens. I don't know if
| there's a way to be sure all calculations are done in VBA?
| Thanks a lot!
| Alex
| --
| Alex St-Pierre
|
|
| "JP" wrote:
|
| Hi,
| Are you using "application.volatile = false"?
|
| Does the status bar say "Calculate" even after you do a manual
| calculation?
|
|
|
| On Oct 4, 2:49 pm, Alex St-Pierre
| wrote:
| Hi!
| I have an excel file that calculate 10 000 simulations. For each simulation,
| I use the Application.Calculate (takes 3 seconds) to refresh the result.
| Thereafter, I copy the interesting result inside a cell and I do it for all
| simulations. The problem I have is that Application.Calculate doesn't refresh
| all the workbook. File= 130 mo.
| Is there anything else I can write to ensure all calculations have been done?
| Thank you!
| Alex
| --
| Alex St-Pierre
|
|
|