Hi guys
I have Excel 2010 installed and have two major workbooks that I we capture daily info into. ( Tables ) Basically a database of info and from that I create pivot tables and charts etc. all this info is on a normal folder on the Network which some of use have access to.
I just seen video on Powerpivot and looks good. How do I go about getting powerpivot to work and what must I do to get it in place.
Will powerpivot look at this Data that I have and then i can create pivot table through Powerpivot.
Will other staff be able to see this Powerpivot and see the info they want ?
Can you help me and send me in the right direction and help me so I know what I have to ask for from the IT guys.
Ps. Please don't tell me to use access , I am happy with EXcel.
Thanks
I have Excel 2010 installed and have two major workbooks that I we capture daily info into. ( Tables ) Basically a database of info and from that I create pivot tables and charts etc. all this info is on a normal folder on the Network which some of use have access to.
I just seen video on Powerpivot and looks good. How do I go about getting powerpivot to work and what must I do to get it in place.
Will powerpivot look at this Data that I have and then i can create pivot table through Powerpivot.
Will other staff be able to see this Powerpivot and see the info they want ?
Can you help me and send me in the right direction and help me so I know what I have to ask for from the IT guys.
Ps. Please don't tell me to use access , I am happy with EXcel.
Thanks
