+ Reply to Thread
Results 1 to 2 of 2

Excel Pivot Table embedded in Form

  1. #1
    Registered User
    Join Date
    05-04-2009
    Location
    Germany
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question Excel Pivot Table embedded in Form

    Hi,

    This is the first Office Problem I couldn't solve on my own or using google. It's a mix of Access and Excel so I hope I posted in the right forum

    I want to embed an Excel Spreadsheet within a Form of my Access Database. No problem there, but: How do I add a Pivot Table in said Spreadsheet, that uses a Query of the Access Database as the data source?

    I can't use a pivot form because i need a lot of fields and access apparently doesn't like that

  2. #2
    Forum Contributor
    Join Date
    12-11-2004
    MS-Off Ver
    2007
    Posts
    137

    Re: Excel Pivot Table embedded in Form

    Hi,

    Did you try the OWC PivotTable object ?

    Regards
    michel
    Last edited by michelxld; 05-06-2009 at 03:34 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1