I'm trying to export my Access pivot tbl to Excel but it will not export the calculated fields that I've added. Does anyone know how to get it to export from Access to Excel and include the calculated fields?
Thx
N
I'm trying to export my Access pivot tbl to Excel but it will not export the calculated fields that I've added. Does anyone know how to get it to export from Access to Excel and include the calculated fields?
Thx
N
Try to add this calculated field manually or by vba in excel07 pivot table instead.