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 !!

Resources