Advertisement

1 - 10 of 750 containing alltags:("pivot") (0 seconds)
I have recently created a few Pivot Table Reports which I have carefully formatted and print out very nicely, but my problem is that whenever the Pivot Table Report is refreshed, it loses all of my...
Zones: Ms Office SuiteDate Answered: 08/03/1999 Grade: A Views: 4
Is it possible to sort the records that are used as column headings in the PIVOT statement of a crosstab query? If so, how do I do this?
Zones: MS AccessDate Answered: 05/18/2000 Grade: A Views: 0
I have been playing around with writing Windows Scripting Components which I call from another language.  One function I am having problems with concerns creating an array of RowFields for the Exce...
Zones: Visual BasicDate Answered: 04/06/2003 Grade: A Views: 0
Hi, I have a 2 queries (qry1 & qry2). They are the same except the where clause is different (where location = 1 in qry1 and location = 2 in qry2). I made a pivot table in a form (frm1) from ...
Zones: MS AccessDate Answered: 07/23/2003 Grade: A Views: 0
Hello. We have  a Pivotal system running. Also, we have LAN users and some mobiles. The start up syncronization in a mobile is very slow and the packages are very heavy (512kb * 100) How can...
Zones: CRMDate Answered: 04/27/2004 Grade: A Views: 0
When I refresh a pivotable in a spreadsheet I have it deletes all the groupings that I have set up. Having to set up new groupings every time kills the whole point of having the pivot table...any i...
Zones: MS ExcelDate Answered: 10/26/2004 Grade: A Views: 0
Hi All, Can somebody give me the problems he/she faces in  Pivotal HTTP sync? What are the problems generally with DSM,ANM and Transport? Your comments would be deeply apppreciated.
Zones: CRMDate Answered: 06/09/2004 Grade: A Views: 0
I am in the process of implementing a Pivotal system for a small number of users (25), and my team are currently experiencing problems with the synchronisation part of the system (as are other peop...
Zones: CRMDate Answered: 10/21/2004 Grade: B Views: 0
To All, Is there a way to filter a pivot table? If I have a Pivot Table of car Makes (Chevy, Ford, Chrysler) in the Rows and  Colors in the Columns (Red, Withe, Blue) and in the Data Area I d...
Zones: MS ExcelDate Answered: 10/21/2004 Grade: A Views: 0
I was wanting to programmtically tap into the datasource of an existing pivottable, without refreshing the existing pivot, and get as a result a flat file.  I imagine I would use all fields in the ...
Zones: MS ExcelDate Answered: 11/10/2004 Grade: A Views: 0