I have a pivot table with a bunch of sales data split into 3 worksheets (so 3 tables.) This file is 65 megs and takes about 2 minutes to open.

1. Is there a better way of doing this? Access database? On our intranet w/ a database background?
2. If I pick a customer on pivot table 1, worksheet 1, can vbscript choose the same customer on all on worksheets?
3. Any way to speed it up if I don't move to option 1 above?
4. Should I create the pivot tables and pull data from Access?

Thanks!