Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jun 2002
    Location
    Michigan City, Indiana, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot table Wizard error (2000)

    When I get to the end of the pivot table wizard, I get an error message that says:

    An error occurred while trying to use the Microsoft Excel PivotTable Wizard. Microsoft Excel returned the following error: 'Unable to get the PivotTableWizard property of the workbook class'

    Anyone ever gotten this before or know what it might mean??? I am running the pivot table from access, not excel.

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Pivot table Wizard error (2000)

    Have you tried a detect and repair on Access? You aren't trying to use the PivotTable wizard with a parameter query are you?
    Charlotte

  3. #3
    Lounger
    Join Date
    Jun 2002
    Location
    Michigan City, Indiana, USA
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot table Wizard error (2000)

    Yes, I tried detect and repair and that didn't work. No, I'm not using a parameter query.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Pivot table Wizard error (2000)

    Am I correct in assuming that you are using Automation to run the Pivot Table Wizard in Excel? If that's the case, perhaps you could post the code here and one of our loungers could spot something causing your problem. If you aren't doing it that way, then we need an explanation of exactly how you are going about your process. BTW, I presume you are aware that there is full Pivot Table support in Access 2002.
    Wendell

Posting Permissions

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