Forum Discussion
Using Excel and Sharepoint files to make a live Reporting Document
Good day, I can not get power pivot to accept cells in a relationship when I have a new branch in the following financial year without loosing visibility of the previous. Also I see when crea...
Creating a live reporting document using Excel and SharePoint can be a powerful way to analyze and visualize financial data across different periods. However, managing relationships in Power Pivot, especially when dealing with changes like new branches or financial years, can present challenges. Let's address your concerns and provide potential solutions.