I'm tearing my hair out!
I have what should be a simple macro to refresh two data tables (external sources) and recalculate a 'dashboard' style worksheet.
If I manually refresh the tables and recalculate - it works.
If I manually step through the macro (F8) - it works
If I run the macro, it only partially recalculates. As soon as the macro finishes, I can press F9 and it will calculate again.
How can this be!?
I have tried to force a second calculation in the macro, but this doesn't work. Stepping through the macro the second calc isn't required (because the first one worked!) and when running the macro, it still ends leaving calculations outstanding.
Can anyone suggest why this might be or what I can to get around this?
For what it's worth, the code is below: