Re: $$Excel-Macros$$ Showing 65536 Rows

2013-03-11 Thread Chaya
Sir, Please suggest me on which format i will select, please see below image : [image: Inline image 1] On Tue, Mar 12, 2013 at 11:47 AM, The Viper wrote: > you should choose .xlsx format while saving your workbook > > > On Tue, Mar 12, 2013 at 11:35 AM, Chaya wrote: > >> Sir, i am using Ms off

Re: $$Excel-Macros$$ Showing 65536 Rows

2013-03-11 Thread The Viper
you should choose .xlsx format while saving your workbook On Tue, Mar 12, 2013 at 11:35 AM, Chaya wrote: > Sir, i am using Ms office 2010. > > -Chaya > > > On Tue, Mar 12, 2013 at 11:28 AM, The Viper wrote: > >> what version of excel are you using? >> Ëxcel 97-2003 has the capability of holding

Re: $$Excel-Macros$$ Showing 65536 Rows

2013-03-11 Thread Chaya
Sir, i am using Ms office 2010. -Chaya On Tue, Mar 12, 2013 at 11:28 AM, The Viper wrote: > what version of excel are you using? > Ëxcel 97-2003 has the capability of holding maximum 65536 rows. > > > On Tue, Mar 12, 2013 at 11:24 AM, Chaya wrote: > >> Sir, >> >>How to View then, Please ad

Re: $$Excel-Macros$$ Showing 65536 Rows

2013-03-11 Thread The Viper
what version of excel are you using? Ëxcel 97-2003 has the capability of holding maximum 65536 rows. On Tue, Mar 12, 2013 at 11:24 AM, Chaya wrote: > Sir, > >How to View then, Please advice me ? what is xlsx format, you mean > Ëxcel 97-2003 Workbook format" ? i already did save as than, ple

Re: $$Excel-Macros$$ Showing 65536 Rows

2013-03-11 Thread Chaya
Sir, How to View then, Please advice me ? what is xlsx format, you mean Ëxcel 97-2003 Workbook format" ? i already did save as than, please suggest experts.. Thanks, Chaya On Tue, Mar 12, 2013 at 11:19 AM, The Viper wrote: > you cannot view more than 65536 rows in prior versions of excel. >

Re: $$Excel-Macros$$ Showing 65536 Rows

2013-03-11 Thread The Viper
you cannot view more than 65536 rows in prior versions of excel. if your excel version is 2007 or above, choose .xlsx file format while saving your workbook. On Tue, Mar 12, 2013 at 11:05 AM, Chaya wrote: > Dear Experts, > > I have a data base which contains more than 1 lacs rows

$$Excel-Macros$$ Showing 65536 Rows

2013-03-11 Thread Chaya
Dear Experts, I have a data base which contains more than 1 lacs rows, When i copy and paste to a new work book, that time all the rows was showing in the sheet, after that i save and close it. After while i open the work book which contains the data base. i am shock by seeing the dat