Pivot Table showing white square instead of component on some PCs

Microsoft OFFICE


  • 1. Property to determine the Data Provider Version
    Hi there, We are using OWC11 and SSAS2005. How can I programatically investigate the OWC object to discover the Data Provider Version ie. what is the property that holds this? We are not trying to change it, but just need to know which version it is for our users that connect. Currently you can right click on a blank section of the filter bar, and this will bring you up the "Commands and Options" dialogue box which will show (amongst other things) the Data Source Version and the Data Provider Version. Thanks in advance
  • 2. como loclizar no arquivo salvar como as notas dosimulados 201 204
    gostaria de ver como eu acho o arquivo que eu usei para salvar notas eu salve como simulado201,204,205,301,302m303,304,305,306.me ajude achar .
  • 3. OWC11 with Vb.Net
    Hi, Appreciate if anybody can post the sample code for the vb.net web application using OWC11 component (not using OLAP). I am not able to find the samples anywhere. Here is my case I need to pull the data from SQL Server 2005 and display on the webpage using OWC11 component. And design the Pivot table like rows, column, filters. Open the Excel file and Save as Webpage is definetly not my solution. Thanks in advance

Pivot Table showing white square instead of component on some PCs

Postby cmljaA » Sat, 03 Feb 2007 02:05:01 GMT


I have developed a pivottable application in ASP.NET and am using the code

<object id="pivot" 

to show the pivot table on the apsx page, on some PCs this results in the 
page showing white square instead of component. Is this due to the CLASSID 
not being recognised or a security issue not loading the component?

All the PCs have Office 2000 or higher installed on them.

RE: Pivot Table showing white square instead of component on some PCs

Postby TGF1dGxvcw » Sat, 03 Feb 2007 21:53:03 GMT


The classid="CLSID:0002E520-0000-0000-C000-000000000046" you are using 
specifies the OWC9 PivotTable AveX Control. So the Office Web Components 9 
(the ones shipped with Office2000) have to be installed.

Make sure, that on alle Computer with Office2K the OWC9 are installed (via 
the Offive Setup) and on all Computers with a newer Office Controls with that 
ID are registered in the Registry.

If they are missing, install them from a Office2000 Professional or Premium, 
or better a newer Version from Microsoft. Mind the Licencing Issues.

Clear skies,

Similar Threads:

1.Getting squares instead letters in word file from other pc

When i copy a word file from Cd
I get it in  squares instead of letters
How can  I  change this problem?

2.Links to Pivot Tables from PC to Mac not showing up

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

In my Excel 97-2004 files - I have some pivot tables. I also have a Summary Sheet that I link to certain cells within the pivot Tables. In Windows - I never had any problems - I would refresh the data and the links would stay. In Mac 2004 - as soon as I opened the file - all the 'GETPIVOTDATA' references had errors or #VALUE. Thus I changed them all by reselecting the cells, noticing that the formula changed to a simple +SHEETNAMEcellnumber format (example - +PivotA4). Thus when I refresh the pivot table - all the cells are now referenced purely by the cell number and don't link to the proper cells anymore. Is there anyway to fix this so that it has the same functionality from Windows as well as Mac version of Excel?

3.Pivot Table showing number "1" instead of actual result

I have a pivot table that I constantly update the data for but when this is 
refreshed on the cells that should show "Known As" I am seeing a number "1" 
instead .
I have tried various ways around this by changing the data page to rename 
this to re-creating the data page but it is always an issue.
Does anyone have any suggestions.
Many Thanks in advance for your responses

4.How can I show all field data in a pivot table, instead of bla

5.pivot tables-drop data in, how to make it show as columns instead

When you drop your data in to the main data field, how do you make it show up 
as columns instead of as rows?  

6. How can I show all field data in a pivot table, instead of blank

7. Pivot Table: Show Description instead Name

8. Pivot Table - Show "0" instead of (Blank)??

Return to Microsoft OFFICE


Who is online

Users browsing this forum: No registered users and 19 guest