I ran fiddlertool and this is what it shows.
User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Trident/5.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 1.1.4322; .NET CLR 3.0.30729; .NET4.0C)
I looked at the registry and found some MSIE...
Added information...
In Excel 2007 if you click on the top left corner of the spreadsheet you get a dropdown that has an 'Excel Options' button at the bottom, click on that and from the list click on 'Save' now you have a choice as to the format you want Excel to save your spreadsheets. Choose...
The problem was solved by opening a xlsx spread sheet and adding data to A1 save it, CLOSE the spread sheet reopen it and the limits goes from 65000 to 1 million lines. I added my 70,000 records and life was good!!
I am trying to copy 70000 records from an Excel 2007 dataset and paste them in to a new xlsx. I am being limited to the old 65000 limitation. How do you stay within the xlsx file format ao I can copy large amounts of data.
Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.