G
Guest
What I did: I Saved my workdbook as a HTM file and added interactivity with pivot table funstionality.
1. The colors I choose in the spread sheet do not keep when I save as HTM and add pivot table funstionality, and I want them to. It makes it easier for others in my group to read the pivot table.
2. The other users cannot use the pivot table options such as filtering etc. I want them to be able to use this option to effectively get the information. Currently when they browse to the link the pivot table options are grayed out but if I browse to the link I can use the pivot table options. Where do I allow anyone to use the piovot table functionality
3. I need to set the column headers to represent the 1st row, when I save as HTM and add pivot table functionalty, for some reason my fisrt row does not become the column headers, but another one I did does. Why???
1. The colors I choose in the spread sheet do not keep when I save as HTM and add pivot table funstionality, and I want them to. It makes it easier for others in my group to read the pivot table.
2. The other users cannot use the pivot table options such as filtering etc. I want them to be able to use this option to effectively get the information. Currently when they browse to the link the pivot table options are grayed out but if I browse to the link I can use the pivot table options. Where do I allow anyone to use the piovot table functionality
3. I need to set the column headers to represent the 1st row, when I save as HTM and add pivot table functionalty, for some reason my fisrt row does not become the column headers, but another one I did does. Why???