GEG
New Member
Hi All,
I need help with the following.
Background:
I´m connecting Excel to a SharePoint list that users continuosly update. Everytime I open the spreadsheet, I refresh the connection to SharePoint.
Addtionally, I have a Pivot Table that uses the list above as Raw Data. The same, I refresh it everytime I open the file, so as to make sure info is up to date.
Help I need with:
This Pivot table refer to Project information. I need to add a TEXT CELL attached to the Pivot Table in order to add comments for each of the Projects, but as the Pivot Table is dinamic and moves as I drilldown the info, I´m not able to get this CELL moving along with the Pivot.
Question: Is there anyway I can add that text column that moves with the Pivot??
Hopefully, you can help me out.
Thanks in advance,
Guido.-
I need help with the following.
Background:
I´m connecting Excel to a SharePoint list that users continuosly update. Everytime I open the spreadsheet, I refresh the connection to SharePoint.
Addtionally, I have a Pivot Table that uses the list above as Raw Data. The same, I refresh it everytime I open the file, so as to make sure info is up to date.
Help I need with:
This Pivot table refer to Project information. I need to add a TEXT CELL attached to the Pivot Table in order to add comments for each of the Projects, but as the Pivot Table is dinamic and moves as I drilldown the info, I´m not able to get this CELL moving along with the Pivot.
Question: Is there anyway I can add that text column that moves with the Pivot??
Hopefully, you can help me out.
Thanks in advance,
Guido.-