iSixSigma

Minitab

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #51638

    Ralph
    Participant

    I am trying to copy & paste a large excel file over 310K rows into minitab but unable to copy anything beyond 65635 rows in minitab. Can anyone tell me why?

    0
    #179554

    CB
    Participant

    Are you sure the excel file has all 310K rows?  Excel files are limited only to 65536 rows.

    0
    #179555

    Ralph
    Participant

    Yes I  have 2007 excel.
     

    0
    #179557

    Bower Chiel
    Participant

    Hi Ralph
    In Release 15 the Help facility states: –
    Minitab worksheet (also called Data window)
    Organizes your data into columns (variables) and rows (individual cases). In addition to raw data, a worksheet can also contain stored constants and matrices, as well as design objects used in DOE procedures. Each worksheet can contain up to 4000 columns, 1000 constants, and 10,000,000 rows. The total number of cells depends on the memory of your computer, but may be up to 150,000,000.Best Wishes
    Bower Chiel

    0
    #181152

    Savage
    Participant

    Not sure you are still stuck on this, but you can import the full dataset from Excel by going to File , Open Worksheet.  I think this is an error in the software. 

    0
    #181155

    Taguchi
    Member
    0
    #181165

    Taguchi
    Member

    The previous post was written by the fake Taguchi (a sick person!)

    0
Viewing 7 posts - 1 through 7 (of 7 total)

The forum ‘General’ is closed to new topics and replies.