470,636 Members | 1,516 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,636 developers. It's quick & easy.

pivot tables have stopped being editable

Hi all,

I created a pivot table that allowed users to select certain customers from a drop down list and display the relevant data - it worked fine but has now stopped allowing them to do that.

At the same time, I can no longer create a Pivot Table with page, row or column fileds. All of the Pivot Table menu items except Refresh Data have greyed out.

I've tried creating a new db with a simple table and pivot and it is the same issue, so not related to the actual database, but MS Access config I guess.

I am using Access 2002. I have read editing MS Access Pivot Tables using Excel but now of the selection items appear on my menus.

Any ideas how I turn things on again?

Mar 5 '08 #1
1 1792
For anyone with the same problem - re-installing Access didn't work but reinstating the whole of the MS Office suite did.

I still don't know what the underlying issue was.

Hope this helps.
Mar 6 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Rob | last post: by
reply views Thread by Rami | last post: by
reply views Thread by Aveeight | last post: by
3 posts views Thread by nikila | last post: by
9 posts views Thread by PeteCresswell | last post: by
3 posts views Thread by Thyag | last post: by
1 post views Thread by Korara | last post: by
reply views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.