Try this:
In the sheet in your workbook that is the "presentation data" have the fields be linked to another worksheet that is just the raw data.
In your VFP app copy the data to Excel using COPY TO...TYPE XLS
Have Excel open the new sheet
Have Excel select the new data and paste it to the raw data worksheet mentioned earlier.

You presentation worksheet should update from the new raw data and you did it all in less than 10 OLE calls.

paul

>It is in VFP tables, then I am putting it into the speadsheet. Part of the reason for doing it this way is that the client I provide these for does not have VFP and wants the info in the spreadsheet.
>
>
>>>>Did you try the export wizard ?
>>>>EXPORT TO FileName TYPE XL5
>>>> [FIELDS FieldList]
>>>> [Scope]
>>>> [FOR lExpression1]
>>>> [WHILE lExpression2]
>>>> [NOOPTIMIZE]
>>>> [AS nCodePage]
>>>>Creates an excel spreadsheet FAST.
>>>>