Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    New York, NY USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    PivotTable Screen Blank (Access 2002)

    I've seen a post on this before, but there was no resolution. No matter what database I use (including Northwind.mdb), the PivotTable screen is completely blank, with no place to put fields other than in columns (which has no value at all). I have reapired Office XP; I have uninstalled it and reinstalled it (this process preserved my custom settings, which I did not expect). Does anyone have any suggestions?

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

    Re: PivotTable Screen Blank (Access 2002)

    When you say the PivotTable Screen, are you talking about the wizard?
    Charlotte

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    New York, NY USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PivotTable Screen Blank (Access 2002)

    No. I am going to the pivotTable screen from the view menu. (I tried the Wizard also, and end up with the same blank screen). Thanks.

    Joe Valentine

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

    Re: PivotTable Screen Blank (Access 2002)

    Sorry, I'm not running XP yet, so you've lost me. Can you get to the property toolbox (or whatever the equivalent is in XP)? In 2000, right clicking on the pivottable in design view gives you a shortcut menu with the Property toolbox as one of the options. From there, you can use the Show/Hide group to get to the fields list. Is this not working in XP?
    Charlotte

  5. #5
    Lounger
    Join Date
    Jan 2001
    Location
    New York, NY USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PivotTable Screen Blank (Access 2002)

    I am assuming that I am getting to the pivottable design view by clicking View, PivotTable (e.g., when I have selected the Invoices query in NorthWind.mdb. I get a blank white screen with the fields in a window. When I right-click on the blank white screen, ALL of the choices, including Properties, are greyed out. Is there another way I can get to the properties of the pivottable?

    Joe Valentine

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

    Re: PivotTable Screen Blank (Access 2002)

    Sorry, I can't help you. It sounds like XP is *very* different from 2000 in regard to pivottables. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

Posting Permissions

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