+ Reply to Thread
Results 1 to 4 of 4

Headers "Show Value As" calculation

  1. #1
    Registered User
    Join Date
    12-10-2018
    Location
    Cali
    MS-Off Ver
    2016
    Posts
    2

    Headers "Show Value As" calculation

    I tried to google this answer, but I cannot find it.

    Whenever I rename the column that does the "Show Value As" calculation it also renames the original column. They seem to be connected.

    Is there a workaround this? Can I make that column independent when it comes to the header?

    For example, the calculation given from year to year, I would like to rename each one to "2016 - 2017", "2017 - 2018", etc., but it's renaming all of them to "2016 - 2017."

    Thank you

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Headers "Show Value As" calculation

    Your project must have a CONDITIONAL FORMAT present which is affecting the Headers row ... or there is some code, perhaps in the sheet module that is creating this error.

  3. #3
    Registered User
    Join Date
    12-10-2018
    Location
    Cali
    MS-Off Ver
    2016
    Posts
    2

    Re: Headers "Show Value As" calculation

    Quote Originally Posted by Logit View Post
    Your project must have a CONDITIONAL FORMAT present which is affecting the Headers row ... or there is some code, perhaps in the sheet module that is creating this error.
    I don't have any conditional formatting or code. I made a simple sheet with three columns of data : date, sales amount, group (A,B,C) and I'm getting the same.

    I attached an example of the issue and I want to avoid calculated fields.

    example.PNG

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,887

    Re: Headers "Show Value As" calculation

    You cannot rename one field with several names, which is what you are attempting to do.
    Rory

+ 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. VBA Updates Pivot Table by cell contents, i want to show "blank" instead of "all"
    By mattinwpg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2017, 10:58 PM
  2. Replies: 6
    Last Post: 11-07-2015, 02:03 PM
  3. If "6343" in cell A3 matches "monthly" in B3 show a "Y" in C3
    By laaxy in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 04-05-2014, 07:38 PM
  4. Replies: 3
    Last Post: 01-02-2014, 02:15 PM
  5. Pivot to show table content in "Values" as-is & not perfrom any Calculation
    By hemantkrishnan in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-30-2013, 08:45 PM
  6. Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working
    By redders in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2011, 03:52 PM
  7. Making the Tools>Options...Calculation "Manua"l Vs "Automatic" a Button.
    By Ecoich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2007, 07:50 PM

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