Forum Discussion

MarcoTorinoi's avatar
MarcoTorinoi
Copper Contributor
Mar 03, 2024

Total Balance Sheet in Excel that sum up the Regional balance sheets, in Sharepoint

Hi,

 

I have 10 Excel files in our SharePoint with the sales data,  one for every region of the world.

 

I would like then to have a Global Excel sheet that should be the sum of of the 10 above regional files.

 

I could do that by opening the 10 excel files in SharePoint and summing each single cells (the relevant link) to the Global Excel Sheet. I should then refresh to get the total, every time somebody change the Regional file.

 

Is there a smarter way to do it? PS: I do not know Power Bi and anyway our company has only Power BI Desktop license.

 

Thanks !!

SharePoint Online

1 Reply

  • Simon_Harrison's avatar
    Simon_Harrison
    Copper Contributor
    Mar 05, 2024
    Hi Marco

    You could use power query to append the data together for the 10 source files

    Given that the 10 is not likely to grow and become many more, this would bring the data together to be like a single file

    Here is an article which could help and shows you a bit more about how it works

    https://www.selectdistinct.co.uk/2023/09/27/append-data-in-power-query/





Resources