Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Question Unanswered: Problem with a published Pivottable using OWC

    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

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091

    Re: Problem with a published Pivottable using OWC

    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.

    Originally posted by imohammed
    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
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Jan 2004
    Posts
    2
    Thanks for your feedback. Do you know if a VB person can edit the code to fix the formatting problem?

    IM

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    I suspect that XL-Dennis could assist. You might want to PM him.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  5. #5
    Join Date
    Dec 2003
    Location
    Östersund Sweden
    Posts
    60
    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
    Kind regards,
    Dennis

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •