Bulk data pull from Google Analytics #Value Issue


I am trying to pull bulk data from Google Analytics & whenever I do it. #Value! is displayed at first for many of the cells. However, on submitting the formula again the main value appears. How do I resolve this issue? Its creating an issue for me