Excel cell data not updating until i press enter

%3CLINGO-SUB%20id%3D%22lingo-sub-2391622%22%20slang%3D%22en-US%22%3EExcel%20cell%20data%20not%20updating%20until%20i%20press%20enter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2391622%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20am%20using%20stock%20market%20software%20which%20supports%20export%20live%20data%20to%20excel.%26nbsp%3B%20Now%20i%20want%20capture%20all%20the%20volume%20and%20price%20tick%20shown%20in%20excel%20to%20be%20copied%20in%20new%20sheet%20for%20further%20analysis%20how%20can%20i%20do%20this.%26nbsp%3B%20pls%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2393608%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cell%20data%20not%20updating%20until%20i%20press%20enter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2393608%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fmicrosoft-excel%2Fct-p%2FExcel_Cat%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fmicrosoft-excel%2Fct-p%2FExcel_Cat%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EHi%20Please%20start%20a%20discussion%20in%20this%20group%2C%20it%20will%20be%20the%20right%20place%20and%20there%20sooner%20someone%20will%20give%20an%20answer!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2417670%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cell%20data%20not%20updating%20until%20i%20press%20enter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2417670%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1064806%22%20target%3D%22_blank%22%3E%40Viral_Shah%3C%2FA%3E%26nbsp%3BThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F963643%22%20target%3D%22_blank%22%3E%40AndrzejX%3C%2FA%3E!%20I've%20moved%20this%20discussion%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_self%22%3EExcel%20discussion%20space%3C%2FA%3E.%20Please%20post%20Excel%20questions%20there%20in%20the%20future%2C%20rather%20than%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Ftech-community-discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_self%22%3ETech%20Community%20Discussion%20space%3C%2FA%3E%20(intended%20for%20questions%20about%20the%20Tech%20Community%20website%20itself).%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

i am using stock market software which supports export live data to excel.  Now i want capture all the volume and price tick shown in excel to be copied in new sheet for further analysis how can i do this.  pls help

3 Replies
https://techcommunity.microsoft.com/t5/microsoft-excel/ct-p/Excel_Cat

Hi Please start a discussion in this group, it will be the right place and there sooner someone will give an answer!

@Viral_Shah Thanks @AndrzejX! I've moved this discussion to the Excel discussion space. Please post Excel questions there in the future, rather than the Tech Community Discussion space (intended for questions about the Tech Community website itself).

@Eric Starker 

Thank you very much!