Pivot table in Excel from Access

[Bernard Pullon]

I have a pivot table that I am trying to create in excel that reads a table
in Access. No problem normally except that I would rather have it read a
select query directly rather than the table produced by a make-table query.
I've had to use the latter method as I have functions called up in the query
that Excel does not recognise. They are my own functions in VB.

Do I need to make the function available to Excel somehow and how do I do
that?

Thanks