New To Excel Queries

G

glam_rock

so i have a huge spreadsheet (approx 45mbs in size) and i have no ide
how to properly query it...
it has way more than the allowed 65,536 entries and i have no idea ho
to query the entries after 65,536...
help please!
 
N

Nick Hodge

Glam Rock

In these instances you are best to leave the data in a better 'data handler'
such as Access and either build a pivot table from this external source
(Data>Pivot table report or chart and use the external data option) or
summarise the data and bring in via Data>get external data...new database
query

Either way you can save the connection and simply refresh the data with new
as it is added.

My preference, wherever possible is the pivot table route as, if you are
summarising underlying data, providing that summary doesn't exceed 65536
rows, you can query many 100,000's of records

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top