Increasing # of rows in excel sheet

[Rehan]

Hi all..

I usually import data from other programs such as SAP
into excel and face the problem of excel running out of
Rows.. is there a way that I can increase the total
number of rows in my worksheet or any other solution
possible to my problem.

Thanks

Rehan

 

[Guest]

Hi
no. 65536 rows is the maximum

 

[JulieD]

Hi

only option that i know of is either to use another database program (e.g.
Access to manipulate the SAP data) or use quattro pro.

Cheers
JulieD

 

[Rehan Akhtar]

so is there a way to expand the formulas to cover more
than one sheet.. eg. Vlookup looks in the data ranges of
more than one sheet to return the value i am looking
for?? and similarly with other formulas?

 

[Rehan Akhtar]

actually to be more precise.. i use pivot table to
generate reports for all that voluminous data... so is
there a way i can give pivot table a data ranges of more
than one worksheet and still get one consolidated report
out of that???

 

[Arvi Laanemets]

Hi

Does exist an ODBC driver for SAP (sorry to ask, but I have no experience
with it) ? When yes, then why don't you query consolidated data from there
directly (summing or counting grouped data) ?

 

[Guest]

Hi
in the pivot table wizard you could choose 'Multiple Data Consolidation
ranges'

 

[Guest]

Hi Arvi
though SAP relies on a 'normal' database (e.g. Oracle, Sybase, etc.) for
which ODBC drivers exist it is NOT a good idea to query the SAP database
directly (and most companies prohibit such direct access)

 

[jaf]

Hi Rehan,
This macro will use multipul sheets.
http://www.google.com/groups?hl=en&lr=&c2coff=1&[email protected]

Using the data in a pivot table is another problem.