how many rows in your spreadsheet, Karen? True 2007 (.xlsx) format allows over a million rows, and columns up to XFD - if you only have 65,536 rows and IV rows, (IIRC) then it's giving you its 'compatible' format rather than full-fledged 2007 file format. On Sun, Jan 8, 2012 at 9:21 PM, Karen Hodges <[email protected]> wrote: > Hi > > I am using 2007 but it didn't fit all the information only chromosome 1 and > 2 bases > > Karen > > On Mon, Jan 9, 2012 at 12:28 PM, Dwight Holmes <[email protected]>wrote: > >> Karen - It's probably not the answer you want to hear, but the newer >> version of Excel ("2007," I believe) handles far more rows and >> columns, and can handle these files.  there may be another solution, >> but i'm not aware of it. >> >> On Sun, Jan 8, 2012 at 7:00 PM, Karen Hodges <[email protected]> wrote: >> > I know this has probably been discussed before but I can't find it in the >> > archives; how do I display the raw data please of my family finder test >> and >> > my dad's in an application? >> > >> > I have tried excel but it says the file is too large to display and only >> > shows the first few chromosomes[?? it lists a lot of 1's and then a lot >> of >> > 2's which I think must be the first few chromosomes]. >> > >> > I would like to compare segment matches we have so any suggestions on how >> > best to do this daunting task or if there is some software to use that >> > would be handy. >> > >> > Karen >> >> >> ______________________________ >> For answers to Frequently Asked Questions about mailing lists, please see: >> http://dgmweb.net/MailingListFAQs.html >> >> >> ------------------------------- >> To unsubscribe from the list, please send an email to >> [email protected] with the word 'unsubscribe' without >> the quotes in the subject and the body of the message >> > > > ______________________________ > For answers to Frequently Asked Questions about mailing lists, please see: > http://dgmweb.net/MailingListFAQs.html > > > ------------------------------- > To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message

Hi Dwight Just tried to open the file in excel again [tried several times before but got an error and only part display] this time both files opened and had 708093 rows in both. Not sure what caused the problem before... unless the computer was trying to open with excel 2003 which is also on the computer. Thank you and everyone else for your help Karen On Mon, Jan 9, 2012 at 1:36 PM, Dwight Holmes <[email protected]>wrote: > how many rows in your spreadsheet, Karen? True 2007 (.xlsx) format > allows over a million rows, and columns up to XFD - if you only have > 65,536 rows and IV rows, (IIRC) then it's giving you its 'compatible' > format rather than full-fledged 2007 file format. > > On Sun, Jan 8, 2012 at 9:21 PM, Karen Hodges <[email protected]> wrote: > > Hi > > > > I am using 2007 but it didn't fit all the information only chromosome 1 > and > > 2 bases > > > > Karen > > > > On Mon, Jan 9, 2012 at 12:28 PM, Dwight Holmes <[email protected] > >wrote: > > > >> Karen - It's probably not the answer you want to hear, but the newer > >> version of Excel ("2007," I believe) handles far more rows and > >> columns, and can handle these files. there may be another solution, > >> but i'm not aware of it. > >> > >> On Sun, Jan 8, 2012 at 7:00 PM, Karen Hodges <[email protected]> > wrote: > >> > I know this has probably been discussed before but I can't find it in > the > >> > archives; how do I display the raw data please of my family finder > test > >> and > >> > my dad's in an application? > >> > > >> > I have tried excel but it says the file is too large to display and > only > >> > shows the first few chromosomes[?? it lists a lot of 1's and then a > lot > >> of > >> > 2's which I think must be the first few chromosomes]. > >> > > >> > I would like to compare segment matches we have so any suggestions on > how > >> > best to do this daunting task or if there is some software to use that > >> > would be handy. > >> > > >> > Karen > >> > >> > >> ______________________________ > >> For answers to Frequently Asked Questions about mailing lists, please > see: > >> http://dgmweb.net/MailingListFAQs.html > >> > >> > >> ------------------------------- > >> To unsubscribe from the list, please send an email to > >> [email protected] with the word 'unsubscribe' without > >> the quotes in the subject and the body of the message > >> > > > > > > ______________________________ > > For answers to Frequently Asked Questions about mailing lists, please > see: > > http://dgmweb.net/MailingListFAQs.html > > > > > > ------------------------------- > > To unsubscribe from the list, please send an email to > [email protected] with the word 'unsubscribe' without > the quotes in the subject and the body of the message > > > > ______________________________ > For answers to Frequently Asked Questions about mailing lists, please see: > http://dgmweb.net/MailingListFAQs.html > > > ------------------------------- > To unsubscribe from the list, please send an email to > [email protected] with the word 'unsubscribe' without > the quotes in the subject and the body of the message >