Refreshing Data loses subtotals

[elzool]

I am currently running a database query from an access db in Excel
2000. I have it set just the way I want, then I decide I'd like a
subtotal of something. I create the subtotals the way I'd like and
save the spreadsheet. Everything is great until I change the data in
the db and click refresh data, at that point I lose my subtotals.

Is there a way to save a spreadsheet and its subtotal functions so it
will retain them the next time it is refreshed?

I was looking at External Data Range Properties and there are
functions I can't understand that may hold the key... or not.

If someone could explain these a bit more so than the tooltips do I'd
appreciate it.

Towards the bottom it shows three radio buttons for:

Inserting cells for new data, deleting unused cells
Insert entire rows for new data, clear unused cells
Overwrite existing cells with new data, clear unused cells

Finally there is a checkbox for:
Fill down formulas in columns adjacent to data.

Any help would be appreciated.
-elz

 

[Anne Troy]

Why not put your subtotals on a separate worksheet?
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

 

[elzool]

This report will all fit on one sheet of paper and I'd prefer it
listed the way I've already got it set up if it's possible.

 

[Anne Troy]

Then just use Data-Subtotals.

This report will all fit on one sheet of paper and I'd prefer it
listed the way I've already got it set up if it's possible.