+ Reply to Thread
Results 1 to 5 of 5

Pivot Table Help

  1. #1
    Debby Bunce
    Guest

    Pivot Table Help

    Good Morning


    I have a pivot table set up and all is ok
    i have set up a macro to copy the data in the pivot table and to paste it
    sumwhere else and to sort it

    all is good, but when i save the spreadsheet and close it down and reopen it
    and run the macro the pivot table shrinks down to 2 rows and 2 colums

    how do i get my data back on show


    Can anyone help


    Thanks in Advance



    Steve







  2. #2
    Muhammed Rafeek M
    Guest

    RE: Pivot Table Help

    can u pls send your file to me: mohdraf@hotmail.com. i hope, i can help you

    "Debby Bunce" wrote:

    > Good Morning
    >
    >
    > I have a pivot table set up and all is ok
    > i have set up a macro to copy the data in the pivot table and to paste it
    > sumwhere else and to sort it
    >
    > all is good, but when i save the spreadsheet and close it down and reopen it
    > and run the macro the pivot table shrinks down to 2 rows and 2 colums
    >
    > how do i get my data back on show
    >
    >
    > Can anyone help
    >
    >
    > Thanks in Advance
    >
    >
    >
    > Steve
    >
    >
    >
    >
    >
    >
    >


  3. #3
    Debby Bunce
    Guest

    Re: Pivot Table Help

    just tell me what i need to do if thats ok


    steve



    "Muhammed Rafeek M" <MuhammedRafeekM@discussions.microsoft.com> wrote in
    message news:68CFAC3F-0260-4575-A2D4-B98C913B1B74@microsoft.com...
    > can u pls send your file to me: mohdraf@hotmail.com. i hope, i can help
    > you
    >
    > "Debby Bunce" wrote:
    >
    >> Good Morning
    >>
    >>
    >> I have a pivot table set up and all is ok
    >> i have set up a macro to copy the data in the pivot table and to paste it
    >> sumwhere else and to sort it
    >>
    >> all is good, but when i save the spreadsheet and close it down and reopen
    >> it
    >> and run the macro the pivot table shrinks down to 2 rows and 2 colums
    >>
    >> how do i get my data back on show
    >>
    >>
    >> Can anyone help
    >>
    >>
    >> Thanks in Advance
    >>
    >>
    >>
    >> Steve
    >>
    >>
    >>
    >>
    >>
    >>
    >>




  4. #4
    Debra Dalgleish
    Guest

    Re: Pivot Table Help

    If you post the code that you created, someone may be able to help.
    Additional details, such as the pivot table source (Excel, Access?), and
    which version of Excel you're using, would also help.

    Debby Bunce wrote:
    > I have a pivot table set up and all is ok
    > i have set up a macro to copy the data in the pivot table and to paste it
    > sumwhere else and to sort it
    >
    > all is good, but when i save the spreadsheet and close it down and reopen it
    > and run the macro the pivot table shrinks down to 2 rows and 2 colums
    >
    > how do i get my data back on show




    --
    Debra Dalgleish
    Contextures
    http://www.contextures.com/tiptech.html


  5. #5
    Debby Bunce
    Guest

    Re: Pivot Table Help

    After having a mess around iv sorted out he problem

    thanks again


    steve



    "Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
    news:44EAF73A.6020507@contexturesXSPAM.com...
    > If you post the code that you created, someone may be able to help.
    > Additional details, such as the pivot table source (Excel, Access?), and
    > which version of Excel you're using, would also help.
    >
    > Debby Bunce wrote:
    >> I have a pivot table set up and all is ok
    >> i have set up a macro to copy the data in the pivot table and to paste it
    >> sumwhere else and to sort it
    >>
    >> all is good, but when i save the spreadsheet and close it down and reopen
    >> it
    >> and run the macro the pivot table shrinks down to 2 rows and 2 colums
    >>
    >> how do i get my data back on show

    >
    >
    >
    > --
    > Debra Dalgleish
    > Contextures
    > http://www.contextures.com/tiptech.html
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1