+ Reply to Thread
Results 1 to 5 of 5

Row Count is Wrong

  1. #1
    Registered User
    Join Date
    06-07-2010
    Location
    Richmond, VA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Row Count is Wrong

    I created a spreadsheet using a XML data source and after I was done the row numbers are messed up. It goes 1, 4, 6 instead of 123456. Nothing's hid or anything. It's like the row numbers need to be reset any ideas?

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Row Count is Wrong

    Post a sample?
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    06-07-2010
    Location
    Richmond, VA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Row Count is Wrong

    Quote Originally Posted by ConneXionLost View Post
    Post a sample?
    I attached a screenshot of the messed up row count. I know it looks like there's hid sells but there isn't...I've tried unhiding everything. Nothing's there.
    Attached Images Attached Images

  4. #4
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: Row Count is Wrong

    great picture but it does no one any good. if you want someone to assist you - you need to upload the actual spreadsheet.

    go to advance - manage attachments - upload.

  5. #5
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Row Count is Wrong

    The blue numbers on the left side (and the arrows in the top row) indicate you have a filter on.

    Go to "Data > Filter > Show All"

    Cheers,

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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