[img]/w3timages/icons/laugh.gif[/img]A new problem. Out of 6 pivot tables pulling data from Access 2k, one of them is giving me an [ODBC][Expected inputs 1] error. The query runs fine. I've tried setting up a file dns to the .mdb and also just used the Excel data wizard to connect to the .mdb file. Any ideas on how to resolve this? I've thought it was solved, but isn't.