How to put in over 65536 rows?

[shrutikhurana]

Hi

How can we put in data on more than the limit for excel - 65536 rows. I don't want to put them in another worksheet coz I have to link this with another one using vlookup- which is very convenient for a single table

please help.


Shruti

[wjohnson]

If you are currently using columns say A thru Z start adding data in AA thru AZ, or go to an ACCESS Database.

[Bob Phillips]

You can't until Office 12 is released.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"shrutikhurana" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi
>
> How can we put in data on more than the limit for excel - 65536 rows.
> I don't want to put them in another worksheet coz I have to link this
> with another one using vlookup- which is very convenient for a single
> table
>
> please help.
>
>
> Shruti
>
>
> --
> shrutikhurana
> ------------------------------------------------------------------------
> shrutikhurana's Profile:
http://www.excelforum.com/member.php...o&userid=29868
> View this thread: http://www.excelforum.com/showthread...hreadid=495708
>