Forum Discussion

Sonashish's avatar
Sonashish
Icon for Resolver I rankResolver I
5 years ago
Solved

Using Combined Excel data and generate new report

Hello   I have multiple Excel Online files with below information, these excel hosted in SharePoint online. Each excel represent to different location like location1, location2, location3.   Exce...
Need Help
  • Sonashish's avatar
    Sonashish
    5 years ago

    Hello Lionel,

    Actually I found that whatever excel I am combining that sheet tab names are different. Once I renamed the sheet name as Sheet1 in all excel, everything was working as I am expected.

     

    However I did not found that in any bloh or post where it is mentioned that if you combine excel, sheet name should be same.

     

    Thanks

    SOna