Results 1 to 27 of 27

Excel pivot table not responding

Threaded View

  1. #18
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Excel pivot table not responding

    I haven't checked all the monetary columns but columns M to R you have formatted as currency (two decimal places). If you change the formatting of those columns you will see that the real values are somewhat different than what currency displays.
    You are testing using values that you entered and not calculated values. That will certainly explain some of the differences. To find all of the differences, all the names would have to be converted to ranges to see what is happening. In addition, you are using percentages and that is another area where errors in precision can occur.

    M
    N
    O
    P
    Q
    R
    1
    Super
    Insurances
    Payroll Tax
    Cost
    Margin
    Hourly Margin
    2
    2.850000
    0.410625
    1.626075
    34.886700
    4.103300
    4.103300
    3
    61.750000
    8.896875
    48.754875
    769.401750
    180.598250
    22.574781
    4
    2.850000
    0.410625
    1.790325
    35.050950
    7.889050
    7.889050
    5
    3.325000
    0.479063
    2.088713
    40.892775
    7.107225
    7.107225
    Last edited by newdoverman; 01-12-2016 at 06:54 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot not responding
    By porepiga in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-03-2016, 03:08 AM
  2. Replies: 4
    Last Post: 06-19-2014, 12:59 PM
  3. Collapse/Expand - Pivot table Fields - Need equivalent option in Excel VBA Pivot table
    By ragavendraph in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2012, 03:00 PM
  4. Excel pivot table? Edit pivot table sub catagory
    By Bowtye8 in forum Excel General
    Replies: 3
    Last Post: 02-23-2012, 02:25 PM
  5. Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  6. Replies: 1
    Last Post: 06-20-2010, 04:00 AM
  7. [SOLVED] Can links between Excel 2003 Pivot Charts and their pivot table b.
    By Mark Allen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-05-2005, 02:06 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