Don't run the Excel Pivot Table off of the Cross tab query. Run it directly
off of the souce table or create a source query. The pivot table can be set
to refresh on open, just make sure that the source mdb file stays in the same
spot.

Otherwise, I assume your are just importing the cross tab to Excel. You need
to place a script into the ThisWorkbook module in the OnOpen event.

How familiar are you with VBA?

"Anthony Viscomi" wrote:

Pivot table won't work, the cell ranges (# of rows, columns will always
reamin the same) may differ from month to month. I need to create some sort
of script that looks for specific values (that I'll define) and copies or
moves the entire range of cells for that value to a new worksheet. I
envision the execution of this script at startup/opening.

"Jim Thomlinson" wrote in message
...
A cross tab query is Access's version of pivot tables. Why not create a
pivot
table in Excel that queries the access database. (Menu) Data - Pivot
Table
in Excel. Take a look at it and give it a try. Doing it this way also
eliminates the pesky 65,535 row limitation in Excel. If not you could also
look at using the query function in excel which could be used to grab data
from your Cross Tab... If you need some more help just ask.

Hope this Helps...

"Anthony Viscomi" wrote:

Hi all!
I'm new to the Excel group; I develop in Access. Here's my
question/dillemma:

I have a client that needs to see there data in XLS format, thus I
created a
script from within Access to dump a specific Crosstab Query into an XLS
work
sheet. The client now wants to see the data grouped by specific criteria
(Divisions) within seperate workbooks in 1 spreadsheet. I almost sure
that I
can't specify workbooks from with MS Acces; thus I need a way of
automating
this process from with Excel. Obviously this can be achieved by creating
a
macro, but I don't know where to start. Example:

I want to look at the 1st column (Division) and copy every corresponding
cell that meets that specific Division criteria to a worksheet.

Any thoughts?
Thanks in advance!
Anthony Viscomi