473,503 Members | 1,797 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Possible fix for Pivot Table grayed out or no row or column sight problem in Access 2002 XP

Hello everyone..

After much searching for the fact that in Access 2002/XP, the pivot
table options (like the toolbar buttons and the add to button) are
grayed out in some cases, I am happy to let you all know that I have
found a fix that worked on our machines...the other symptom is that
the pivot table background is white with no place to put fields in
rows or columns.

The cause: The Office XP Web Components are not properly installed.

The solution: Go to this site:
http://www.microsoft.com/downloads/d...displaylang=en

and download and install the Office XP Web Components.

Again, there are no guarantees here but it worked for me. Feel free
to drop me a line if it works. Good luck!

The Sports Fanatic :)
Nov 12 '05 #1
0 2200

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
5249
by: Clive Moss | last post by:
I am in the middle of writing a system for a client who has Access 2000 installed on 8 PC's I have Access 2002 and the system I have written relies on pivot tables to display results. I now find...
4
3861
by: Brian Andrus | last post by:
Ok. I upgraded to MS Access 2003 recently and now I am having great heartache. In Access 2002, when I opened a table to view the data, there were wonderful little "plus" signs that I could click...
1
2948
by: Joe Harris | last post by:
I've searched everywhere but can't find a KB article or forum message about this one... Excel Pivot Tables differentiate between +0 (zero) and -0 (negative zero)and now that I've moved over to...
1
2711
by: SJM | last post by:
I have a reporting database that has a series of pre-defined Pivot Table screens. What I would like to do is to enable users to be able to save their own configurations. I found 2 ways of doing...
3
10241
by: Jerry K via DotNetMonster.com | last post by:
I'm creating a pivot table using vb.net and the data is from sqlserver (desktop). I have been successful at creating the pivot table, which includes a 'date' column field. I'd like to group the...
13
17108
by: salad | last post by:
Operating in A97. I didn't receive much of a response conserning Pivot tables in Access. Pivot tables are nice, but a CrossTab will work for me too. Using a Pivot table, one is actually...
3
1855
by: fperri | last post by:
I have a pivot query that is populated with rates returned based on options that user selects on a form. My issue is: They can either select one lender to see on the report, or a combination...
1
1907
by: STUFIX | last post by:
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. ...
0
2120
by: Clare CAVS | last post by:
I have a table with a lookup column referring to another table . tblRooms has two fields, (Autonumber), and . The column I want to display is the RoomName column. If I have Bound Column = 1,...
0
7199
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7076
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7323
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6984
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7453
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
4670
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3162
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1507
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
377
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.