>>Hi Hilmar.
>>
>>I thought I might have to do something like that... the only thing is that the Excel spreadsheet contains about 30,000 lines and there could be a no. of such formulae.
>>
>>I was hoping there might have been an easier way !!!
>
>Perhaps there is, I am not sure.
>
>Anyway, you could just select everything, and Copy & "Paste Special" into a new spreadsheet.
>
>If you need to do this once, it should be fairly quick to do it manually.
>
>If you need to do this on a regular basis, you should use Automation, to invoke it automatically from VFP.


Somewhere I have code for doing just this in automation ... email me if your interested Gerard.