+ Reply to Thread
Results 1 to 2 of 2

Formula1, Formula2 appearing as row items in pivot table where row labels previously were

  1. #1
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    2,709

    Formula1, Formula2 appearing as row items in pivot table where row labels previously were

    I was greeted by a spreadsheet that my wife was using that she had messed up. A table than previously showed date, time, address and hours , was now replaced by date, time, formula1, formula2....formula7 as the values in a column and then the duration.

    this was solved by going to pivot table Analyse, Fields, items & sets, solve order and deleting the formulas from there. then the addresses reappeared in the pivot table when it was refreshed

    So I have no urgent need for a solution, but I am curious if anyone can shed light onto how she could have created this in the first place. she would not be deliberately changing anything, he involvement usually consists of cutting and pasting data to a table and pressing refresh on a pivot table. I suspect some random keystrokes?

    Ideally I want to prevent this occurring again in the future, so I do not have to fix it at 2am in the morning! This was office 2016 if that helps

    As I fixed the spreadsheet and saved, I do not have a workbook in this state to post (it was late)

    Any insight appreciated.

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    2,709

    Re: Formula1, Formula2 appearing as row items in pivot table where row labels previously

    I found the answer myself. So the following link explains how the problem is created

    https://www.pivot-table.com/2014/02/...culated-items/

    if you select a row item and go to the botttom right of the cell to the black cross hairs and drag down, it inserts formula1, formula2 formula3 depend how far you dragged it, and the appear in multiple cells in the pivot table.

    The solution is as listed above

    Going to pivot table, Analyse, Fields, items & sets, solve order and deleting the formulas from there. then the addresses reappeared in the pivot table when it was refreshed

+ 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. Pivot table missing row labels for Random select few items
    By RS.Static in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-29-2016, 04:09 PM
  2. [SOLVED] Looping through Formula1 and Formula2 of FormatConditions?
    By vaute in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-05-2014, 07:13 PM
  3. Change chart/pivot table numeric labels to associated text labels
    By petschek in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-07-2014, 05:32 PM
  4. Pivot Table - Show Row labels horizontally (Not as Column labels)
    By Catsup in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-16-2014, 01:15 PM
  5. Replies: 0
    Last Post: 07-03-2012, 11:09 AM
  6. Get rid of Formula1 in a pivot table (Excel 2007)
    By jrussell in forum Excel General
    Replies: 0
    Last Post: 11-11-2008, 12:38 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