ShowDetail in pivot table

Hi everybody.
I have a pivot Table but the source info is from an Access Table. I need to open the source information, but it is too big for excel, so I would like to know if I can use the "Pivottable.ShowDetail = True" property but telling it to place the retreived information somewhere else, like an access table or a text file, or anything, thanks a lot.

Hi,

Have you tried to change pivot table cache size ?

Carim

Thanks for your response.
No I haven't. I will try, but I am not sure if it will work, cause the problem I have is that when I try to see the source it reaches Excel max rows, like 65k.