i,
I have a pivot table created using 'external data' from an Access data
source using a dsn. Now, when I use the '!' form the pivot tbale toolbar, it
hangs. perhaps because of too many rows 50000. Can anybody help on how to
fix this issue? any type of vba code to set some kind of property?

please help
thanks
Kanan