Opening SharePoint list with Access - Tables are fine, but my pivot charts show up multiple blanks for some reason RRS feed

  • Question

  • I've been reporting with Access from SharePoint lists with no issues until today.

    On List is behaving rather strangely.

    The list has choice, text, date and number columns..

    If I open the list with access or try to create an access view the table shows up just fine, just like my list.

    If I try to create a pivot chart however when I use the field chooser to pick certain columns..  rather than I see a few items in each column I get one massive column called (Blank) i.e. it's not picking up all the data. #

    E.g. Column 1 say was colours it has 4 items of blue, 15 of red and 7 of green.... instead of a column for each of these in my pivot chart I get 4+15+7.....I get one colum with 26 (Blanks) on it. :(

    Any ideas why the data from the table is not showing up correctly.:(

    Tuesday, October 4, 2011 9:47 AM

All replies

  • I've never found the pivot chart in Access of much use, but I do love a good crosstab query.  If you make one of those from the list does it behave properly?
    Steve Clark, MCTS | Twin-Soft.com
    Tuesday, October 4, 2011 2:20 PM
  • Pivotchart feature had been disabled by microsoft on Ms. Access 2013 ,.
    Wednesday, November 28, 2012 3:47 PM