M
Mike The Newb
I have several Access queries in pivot view that are exported to Excel to be
manually pasted into an existing Excel file that I have open already.
"Randomly" the exported pivot will open a new session of Excel and after
pasting the pivot into the other session it loses its drill down capability
(this always occurs when pasting a pivot between Excel sessions regardless of
Access involvement).
How can I ensure the Access export won't open a new Excel session when I
choose to export a pivot?
Many thanks in advance,
Mike
manually pasted into an existing Excel file that I have open already.
"Randomly" the exported pivot will open a new session of Excel and after
pasting the pivot into the other session it loses its drill down capability
(this always occurs when pasting a pivot between Excel sessions regardless of
Access involvement).
How can I ensure the Access export won't open a new Excel session when I
choose to export a pivot?
Many thanks in advance,
Mike