Synchrotron studies show balance is the key to catalysing methanol production