By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,707 Members | 1,279 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,707 IT Pros & Developers. It's quick & easy.

pivot tables have stopped being editable

P: 3
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
Share this Question
Share on Google+
1 Reply

P: 3
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.