Yes, you can use external data source for pivot tables in Excel.
The easiest way to see how it should be coded is to record a Macro in Excel, and then translate VBA code to VFP.

>I have created a new database with a view which pulls data in from various tables in foxpro.
>
>Is there anyway I can use this as a source for my pivot table in Excel without having to import tha data into excel first then create a pivot table?
>
>Any advice would be greatly appreciated
>
>Many thanks