+ Reply to Thread
Results 1 to 5 of 5

Pivot Table & Adding free text column

  1. #1
    Registered User
    Join Date
    05-30-2014
    Posts
    44

    Pivot Table & Adding free text column

    Hello,

    I am hoping to ask for some assistance in how I can add a free text column to a pivot table in which I have slicers activated. I would like a "Comments" column at the end of the pivot table. I would normally just copy and paste this table into a new worksheet but since I have slicers, I don't know how I would go about adding this free text column that works with the pivot table.

    Thank you for your help!

  2. #2
    Registered User
    Join Date
    05-30-2014
    Posts
    44

    Re: Pivot Table & Adding free text column

    Oh and I should mention that I am working in Excel 2010!

    Thank you again!

  3. #3
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Pivot Table & Adding free text column

    Hello
    Pivot tables are linked to their source data as such you can't change or add to them, apart from Calculated fields based on existing Pivot table data. If you want a comments column it has to be in your source data.

    DBY

  4. #4
    Registered User
    Join Date
    05-30-2014
    Posts
    44

    Re: Pivot Table & Adding free text column

    Well crud - I was afraid that would be the answer.

    Let me ask this then - is there a way to create a hyperlink in the pivot table to link to another worksheet?

  5. #5
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Pivot Table & Adding free text column

    Sorry, not that I'm aware of.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 08-19-2015, 07:46 PM
  2. Adding a formula column based on the pivot table's Grand Total column
    By trisoldee in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-26-2014, 05:29 PM
  3. Pivot table- adding a column
    By bojker in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-21-2012, 04:33 PM
  4. [SOLVED] Pivot Table adding % increase column
    By Molson_Canadian in forum Excel General
    Replies: 4
    Last Post: 05-29-2012, 02:06 PM
  5. Adding a column to a pivot table
    By ezzy85 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2008, 03:01 AM

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