Will ANYONE HELP!!!! this is my 4th posting

[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???

 

[CLR]

Sorry Neall, I'd love to help but you're out of my area......maybe you might
have more luck over in the microsoft.public.excel.misc group with a
Subject line of "Need Pivot Table help" or something like that......

Vaya con Dios,
Chuck, CABGx3

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???