Forum Discussion

Sonashish's avatar
Sonashish
Resolver 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

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Sonashish ,

 

Is it like this?

The reason is that the column names of the tables in different Excel files are different.

If the tables have the same field names, they can be merged.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Sonashish's avatar
Sonashish
Resolver I
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