+ Reply to Thread
Results 1 to 2 of 2

How to fix #div/0 error in pivot table excel 2007

  1. #1
    Registered User
    Join Date
    01-16-2018
    Location
    Athens, Greece
    MS-Off Ver
    Microsoft Office Exel 2007 (for Windows)
    Posts
    25

    How to fix #div/0 error in pivot table excel 2007

    Hello! I have a problem. I am trying to calculate an average on a pivot table and it shows the #div/0 error instead of values. I don't have a blank or a 0 value cell anywhere. Can anyone help? Thanks!

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: How to fix #div/0 error in pivot table excel 2007

    Posting a sheet might help (see yellow banner)
    Perhaps you have text looking like numbers?

+ 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. Excel 2007 - Pivot Table: “Cannot Group That Selection” error!!
    By alsalms3 in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 01-13-2013, 01:23 PM
  2. [SOLVED] Excel 2007 : Month/Year Format with Pivot Table - Excel 2007
    By db1966 in forum Excel General
    Replies: 3
    Last Post: 05-17-2012, 04:35 AM
  3. Pivot Table (Excel 2007)
    By Dark Nation in forum Excel General
    Replies: 3
    Last Post: 09-16-2011, 03:17 PM
  4. Excel 2007 Pivot Table
    By LB79 in forum Excel General
    Replies: 2
    Last Post: 11-24-2010, 07:32 AM
  5. Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  6. Replies: 1
    Last Post: 06-20-2010, 04:00 AM
  7. Excel 2007 pivot table/macro/Runtime error 1004
    By abalserv in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2010, 06:36 AM
  8. Pivot Table Excel 2007
    By Justinetme in forum Excel General
    Replies: 0
    Last Post: 03-27-2008, 09:02 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