Results 1 to 2 of 2
  1. #1
    nagiese is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2011
    Location
    Nashville, TN
    Posts
    43

    Question Export Access '07 Pivot Tbl to Excel'07


    I'm trying to export my Access pivot tbl to Excel but it will not export the calculated fields that I've added. Does anyone know how to get it to export from Access to Excel and include the calculated fields?
    Thx
    N

  2. #2
    thhui is offline Competent Performer
    Windows XP Access 2002
    Join Date
    Feb 2009
    Posts
    235
    Try to add this calculated field manually or by vba in excel07 pivot table instead.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Pivot table - access to excel
    By antagonia in forum Access
    Replies: 3
    Last Post: 12-16-2011, 01:57 PM
  2. Converting an Access pivot query to SQL 2005
    By csharpnewbie in forum Queries
    Replies: 1
    Last Post: 10-05-2010, 04:22 AM
  3. Export Pivot table to Excel Error
    By Whalen16 in forum Import/Export Data
    Replies: 3
    Last Post: 09-30-2010, 12:54 PM
  4. Export Access Pivot Table to Excel
    By graviz in forum Programming
    Replies: 1
    Last Post: 11-13-2009, 07:30 AM
  5. Pivot table graph form export to powerpoint
    By maati1980 in forum Forms
    Replies: 0
    Last Post: 10-22-2009, 02:59 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums