Extracting/importing data from an excel sheet with merged cells

%3CLINGO-SUB%20id%3D%22lingo-sub-830156%22%20slang%3D%22en-US%22%3EExtracting%2Fimporting%20data%20from%20an%20excel%20sheet%20with%20merged%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-830156%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-note-subject%20lia-component-subject%22%3E%3CDIV%20class%3D%22NoteListSubjectCell%20message-subject%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22lia-note-body%20lia-component-body%22%3E%3CP%3EI%20created%20a%20excel%20work%20book%20with%203%20sheets.%202%20are%20of%20charts.%20The%20main%20page%20is%20where%20all%20my%20data%20is%20input.%20I%20need%20to%20send%20this%20information%20to%20an%20company%20I%20am%20working%20with%20that%20has%20a%20program%20that%20will%20extract%20the%20data%20from%20it%20and%20utilize%20it.%20However%20I%20am%20being%20told%20it%20wont%20work%20because%20of%20the%20merged%20cells%20in%20the%20spreadsheet%20I%20made.%20Is%20there%20a%20way%20to%20send%20this%20file%20out%20and%20the%20recipients%20program%20still%20be%20able%20to%20extract%20the%20data%20it%20needs%20from%20it%20without%20having%20to%20unmerge%20all%20the%20cells%3F%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-830156%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EYammer%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-831862%22%20slang%3D%22en-US%22%3ERe%3A%20Extracting%2Fimporting%20data%20from%20an%20excel%20sheet%20with%20merged%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-831862%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F400658%22%20target%3D%22_blank%22%3E%40Reception8191%3C%2FA%3EThis%20doesn't%20seem%20to%20be%20related%20to%20Yammer.%20Consider%20asking%20in%20the%20Excel%20community%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fct-p%2FExcel_Cat%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fct-p%2FExcel_Cat%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
 

I created a excel work book with 3 sheets. 2 are of charts. The main page is where all my data is input. I need to send this information to an company I am working with that has a program that will extract the data from it and utilize it. However I am being told it wont work because of the merged cells in the spreadsheet I made. Is there a way to send this file out and the recipients program still be able to extract the data it needs from it without having to unmerge all the cells?

1 Reply

@Reception8191 This doesn't seem to be related to Yammer. Consider asking in the Excel community

https://techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat