Help: pivot chart data in secured Access database wont show fields

A

A C

Hello

Is there a way for me to crate a pivot chart in Excel where the data is in a
secured access database.

By default (ie using system.mdw) the Access security allows a user view
permissions on the tables. When connecting to the database the tables are
visible, but the next step where the fields get shown doesnt happen, no
fields can be selected.

Is this a security issue? Is there a way around this?

Thanks
A
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

1 for Debra? - Pivot Chart calculated field? 3
refresh pivot chart 1
Pivot table chart problem, How to show different subtotal levels 2
Presenting all months in a year in a Pivot Table/Chart when allmonths are not included in source dat 0
Pivot chart loses data connection when copied to new workbook 1
Pivot chart series label 1
Slicers and Calculated Items in Pivot Table 2
Pivot Table with Data Model Connection - getpivotdata reference issue 0

Top