Horizontal scroll bar in PivotTable?

[Michael Austin]

All

I'm using the pivot table control on my form. Everything works as expected except for the fact that I can't get the horizontal scroll bar to appear when the PivotTable exceeds the size of my form. If I place columns in the Column Area of the PT, then the horizontal scroll bar appears and works. Otherwise, I can't get the horizontal scroll bar to appear. (My users will not be happy with being forced to include a column area field...) This appears to be a defect. Is there a work-around

TIA

Mike

 

[James Kelloway]

Dear Mike

I've had a similar problem when calling the OWC9 from an ASP page. We have moved to using OWC10 (XP) and the horizonal scroll bar issue went away

Good luck

James

 

[Michael Austin]

Thanks, James! I have two questions:

1. How do I determine what version of OWC I have?
2. Where can I download OWC10?

I believe that the pivot table service is located in the
PTSFull.exe file. This program installs the pivot table
services and MDAC. My version of this program came with
SP3a of SQL Server 2000.

I also have Excel XP installed on my PC. The rest of my
Office components are from 97 and 2000. Clearly, Excel XP
did not install the pivot table control as well, since my
pivot table still has the problem.

Thanks for your response.

Mike A.

-----Original Message-----
Dear Mike,

I've had a similar problem when calling the OWC9 from an

ASP page. We have moved to using OWC10 (XP) and the
horizonal scroll bar issue went away.