Hi Guys
I have a calculation sheet that is currently bringing in data from 3 external sheets in order to be able to create reports and graphs for dashboards etc
My problem is that I am conscious I will reach my cell link limit, along with the fact that 3 or 4 more sheets will soon have to be included in calculations, meaning I will have to add in calculations and cell link manually.
Our organization has the Pivot App add on - is this the solution to my problem?
Will the Pivot App enable me to create a calculations sheet from multiple other sheets and somewhat automate what is a manual process at the minute?
I am somewhat confused as to what the purpose and benefits of the Pivot App is
Any info much appreciated !