All contents of Pivot Table does not show up in form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a pivot table in Access using the Pivot Table Wizard. It looks
fine in excel, however when viewing it in from the Access form, all the
contents does not appear. I tried enlarging the height of the form, but that
only gives more white space. It looks like the missing contents can easily
fit in the extra white space, so the issue shouldn't be the size of the Pivot
Table. Can anyone help?
Thanks!
 
I figured out a work around for my issue. I highlighted and copied the pivot
table in excel and pasted it in the Access form, instead of following the
steps of the Pivot Table wizard.
 
After doing the work around several times, I finally figured out the answer.
When your in design view of the form, right click on the pivot table and
select Workbook Object and then Edit. This will allow you to make any
changes to the pivot table and let you resize the pivot table so all contents
can be viewed. Just wanted to share this info just in case anyone
experienced the same issue. Thanks!
 
Back
Top