The most common source for pivot tables is an Excel list. Just about any list can be made into a pivot table, however, the list should have the following characteristics: least one field, and best if it's two or three fields, that is "groupable" in that the field contains a limited number of distinct data (text, numbers, or dates) Shortcut: You can also access the PivotTable Wizard using the PivotTable Wizard button on the Query and Pivot toolbar.

The PivotTable Wizard can assist you in creating a pivot table from an external source such as an Access, FoxPro, or SQL Server database. With Microsoft Query installed on your computer, the PivotTable Wizard will load Microsoft Query so that you can create a result set for the data you want to analyze. See similar questions...

A pivot table is a powerful tool which allows you to roll up, filter and sort structured data along any of the dimensions or axis which define your numbers. See similar questions...

There is no built-in way to accomplish that. However, see http://www.cdolive.net/download/bulkaddfromexcel.zip for a Windows Scripting Host script that uses an Excel table to create users and mailbox enable them. Either open Outlook to create a new message with that SMTP address and hit "CTRL+K" to resolve it, or use a Windows Scripting Host script to find it. For the latter, see http://www.cdolive.net/download/adusermanagement.zip (look for FindUserWithADSI.wsf and FindUserWithCDO.wsf) See similar questions...

Usually you will want to turn off the row and column grand totals otherwise they will distort the chart. In Excel 97 all you then need to do is to click on a cell anywhere within the pivot table, and then run the chart wizard. With earlier versions of Excel you will need to select the area yourself. See similar questions...

Save your Excel file as a tab-delimited ".txt" file, and then it can be properly imported into an HTML table. You are welcome to send us just the delimited text file as such. We do not post Excel files. See similar questions...

You can easily consolidate multiple ranges using Pivot Tables as long as the ranges you are dealing with have identical row and column labels. This procedure is accomplished using the Data - Consolidate command. However, using the PivotTable Wizard results in a table that is more flexible and customizable than the static table produced by Excel's Consolidation feature. See similar questions...

You can create favorite lists for hosted suppliers on the eCAT3 site. Punch-out supplier favorite lists are maintained on the specific vendor website. Create a favorites list by clicking the “add to favorites” button from a cart or product search results. See similar questions...

Google has a free web based excel tool you can use to view excel sheets. See Google Docs & Spreadsheets for more information. See similar questions...

When the data table object is opened in the Full Editor, it will allow you to copy and paste from an excel file into the table (this should work for any tab-delineated text or data). See similar questions...

It's very easy. Click on the becoming a dealer link and fill out the application and then click SUBMIT. We will receive your request and e-mail you username and password back within 24 hours. You will then be able to log on in the upper right corner of the home page and have complete access to our dealer catalog and all of our price lists. These are updated every 24 hours so please check for new products or specials. See similar questions...

You can add a table to any page that allows you to add text. To add a table, click on the icon located in the toolbar for "insert table". Enter the number of "rows" and "columns" you will be using (value must be 1 or more). Now you can fill out the "table attributes". Border= this refers to the border around the table or the outline of the table, so if you want to have the border thicker or more visible increase the value. See similar questions...

The ease with which you can create a table of contents will be directly related to how well you know the intricacies of your word processing program. Microsoft Word, Works, Word Perfect and Open Office all have the capacity to create tables of contents, but some writers still find it more expedient to create them manually. Second, your table of contents page should be located after the Copyright page, Dedication page and Preface page. See similar questions...

You cannot. Queries spanning more than one table are currently not supported in OpenOffice.org's own dBase implementation. There is an issue requesting this, so if you're interested in this feature, go and vote for it. See similar questions...

You can write a letter at support@eephp.com with detailed description of feature you need, and if we decide that it can be useful to other customers it have all chances to be included in the next release of the product. See similar questions...

Click Get class data and click on a course name.At the bottom of the class list, click Download Student List. On the next screen, ensure Excel format is selected in the drop-down menu and click Download student list. Click Save on the pop-up message screen. Next, choose a location on your computer where you would like to save the file, click Save. Go to the location where you saved the file and double-click it to open it in Excel. See similar questions...

Go to the Management Console > Jobs Management > import: select the corresponding option and paste the results data either browsing to locate the file or copying/pasting the complete URL. Caution, the URL must be accessible from the Phenyx server. Once imported, the jobs are available on the Desktop. Select the jobs and choose Compare from the Actions on Selected drop-down menu to access the Results Comparison page. See similar questions...

J.R. will stop Mid-match actions but cannot stop the use of Pre-match cards used as Mid-match actions because J.R. specifically says it affects Action CARDS, not cards that simulate Actions. See similar questions...

The Ultralight Control Systems pivot has revolutionized underwater photography. Our pivot allows the photographer to convert his camera set up from horizontal to vertical in less time than it takes his/her strobes to recycle. A simple push of the button on the back of the pivot moves the camera. The strobes never need repositioning when you switch the camera from vertical to horizontal format. See similar questions...