Increasing # of rows in excel sheet

R

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
 
J

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
 
R

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?
 
R

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???
 
A

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) ?
 
F

Frank Kabel

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

Frank Kabel

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)
 
Top