>PS: Moving fields to different positions (ie: exchange yearOrdered with salesman or add to salesman or move to first position etc) show different summaries. Also simplest pivot show a single "data" item (the numbers) while you could add multiple calculations (like you can show sum, count, frequency, percentage of an item instead of just quantity sold). Click a number and + from toolbar:)
>
>Cetin

Hi Cetin,

IF .F.
     Perhaps you know how to do this.  First create a cursor with string fields, some of which contain numbers as strings (for 
     example "  5.00") and other contain formulas as strings (for example "=SUBTOTAL(9,H4:H10)")

     Next, send the cursor to Excel via ADODB as before.

     Now, how do you convert the strings to Excel numbers and formulas from VFP using automation?
ENDIF

Found a simpler approach:
1) Insert subtotal lines directly in cursor in appropriate place: values not formulas,
2) Export cursor to Excel as usual
3) With automation, create outline as explained in this page: http://www.ozgrid.com/Excel/outlining-manual.htm

Thanks,

Alex

P.S.
Just realized that if I want to use autofilter technique with a line of subtotals the intermediate subtotals (which are values and not formulas in this approach) will be double counted. That doesn't happen if intermediate subtotals are formulas. Hmmm...