Hi

I am trying to use the transfer spreadsheet function to export a crosstab
query to a named worksheet in a workbook.

The worksheet already exists and when i call this function it creates a
"worksheet1".

Is it possible for it to overwrite the existing worksheet without renaming it?

I have look up functions that reference this worksheet and therefore i
cannot just create a new worksheet, the formulas will fail.

Please accept my thanks

rgds
Colin