Pivot Tables in Excel Linked to Data in Access

[CUNY01]

I created Pivot tables in Excel2007 based on data in an access Database query. However I had to add a field (function) to the query. When I try to refresh the pivots in excel I get "Undefined function 'Name of Function I added' in expression" How do i fix this?

 

[SkipVought]

hi,

What code or function did you use for your "field (function)"

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[CUNY01]

MonthName(Month(DateField))

 

[SkipVought]

use

FORMAT(DateField,'mmmm')

instead of your user defined function. which MS query knows absolutely nothing about.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[CUNY01]

It works. Thanks a mil for your help.

Now I know.