Macro steps overrun by server running very fast

[03aviator]

Has anyone encountered a situation where when running a macro in Excel (Office 2010) on a fast server, the steps in the macro are rushed through so that the file cannot finish re-calculating before the macro moves to the next step causing errors in my data. I have tried putting a puase command in the macro right after the turning on automatic calculation again, but this does nothing for my problem. I have tried putting the following steps into a separate macro that is called at the end of the calculation abeing turned back on and it still doesn't work. This is happening in an Excel file that is 28,406 KB in size with many complicated formulas in it.

Any suggestions would be greatly appreciated on how to stop the macro from proceeding until the recalculation is completed.

Thanks all.

 

[Linde]

Would it be possible to create an calcultated field that gets a specific valua at the end of the calculation?
You good then create a look that looks to that field until it has that value and then run the next macro.
something like:....

cells(1,1).value="calculating"  'calculation executed by other macro
do
if cells(1,1).value="done" then
do_macro
cells(1,1).value="oke"
end if
loop until cells(1,1).value="oke"

 

[03aviator]

I will try this out - see if I can get this to work.

Thanks for your help!