Thanks for replying..
The data is in Access tables, but the summary information will be in Excel. Currently, I run ACCESS queries and paste the results into Excel. I like the list feature because it allows a user to group by specific values, but also allows the user to "drill-down" to a single complete record for researching discrepancies. However, my spreadsheets contain a lot of formatting AND each refresh will change the number...

I noticed EXCEL can automatically update a list from SharePoint services.

Is there a quick and easy way to update a list from an Access query?

Is it "better" to create the code in ACCESS and reference excel or to create the code in EXCEL and reference access?

My Software:
Microsoft Windows XP Professional Version 2002 w/Service Pack 2
Microsoft Office Professional Edition 2003...