Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Oct 2007
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2007 - Pivot table problems

    Am trying to create a pivot table in Excel 2007.

    When I select the destination for my Pivot table I get the dialogue boxes in the attached file (basically it states I can't put it in any other spot apart from the current worksheet).

    Any suggestions?

    Thanks.
    Attached Files Attached Files

  2. #2
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts
    Hi, The only thing I can think of without seeing your file, is to check that the source data has no gaps between the headings and the data to be pivoted.

    Regards,
    Maria
    Maria
    Simmo7
    Victoria, Australia

  3. #3
    New Lounger
    Join Date
    Oct 2007
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Maria

    Thanks for the reply. The data pivots perfectly in Excel 2003, we get the same message with every file we try.

    Very frustrating.

    Regards
    Susan

  4. #4
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts
    Susan,

    Would you be willing to upload your file? If you have sensitive data, I suggest you replace it with dummy data. Once you have uploaded your file I can have a look at it in Excel 2007.

    Regards,
    Maria
    Maria
    Simmo7
    Victoria, Australia

Posting Permissions

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