I am running Office 2003 on my machine and are able to publish a pivottable report using OWC. The problem I am experiencing is that the published pivottable's layout is different from the Excel pivottable and I am not able to save it so that it looks like the Excel pivottable. Does anyone know how to publish the pivottable so that the layout does not change. Thanks in advance

I don't have Office 2003 (only on Office 2002). I know that in previous versions of Excel when saving as html file there are some formatting issues, and it will not look exactly as it does in Excel. Thus, even when you edit, it might look good in Excel, but saving again to update/publish will lose some of the formatting.

Thanks for your feedback. Do you know if a VB person can edit the code to fix the formatting problem?

IM

I suspect that XL-Dennis could assist. You might want to PM him.

Hi guys,

Post it in this thread enabling other people to take part of it.

I strongly believe that knowledge is best when its shared

Kind regards,
Dennis