Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Criteria for external data in a pivottable
8 views
Skip to first unread message
Peter
Aug 21, 2012, 4:54:57 AM8/21/12
to
Excel 2010
My pivottable is based om external data. The datasource is a view
showing data for multible sites and years.
Is it possible to set a filter so that I only receive e.g. data for
this year ?
Regards
Peter
My pivottable is based om external data. The datasource is a view
showing data for multible sites and years.
Is it possible to set a filter so that I only receive e.g. data for
this year ?
Regards
Peter
Peter
Aug 21, 2012, 5:42:35 AM8/21/12
to
I got it.
The answer is to change the Command Type and Command Text in the
Connection Proerties.
Regards
Peter
0 new messages