Do any newer versions of Excel (2003 or XP) offer more than 65,53.

S

SAPDataWizard

I need to summarize global inventories from mutliple countries and the data
exceeds 65,000 records.

If I could store 125,000 records - Pivot tables would give me all I need.

I prefer not to goto Access unless I have to......
 
K

Ken Wright

Answer is no, but just use Access to store your data and do all your Pivot
Analysis from Excel using Data / Get External data. I literally use Access as a
storage bucket for the data when I have that many rows to play with. Don't even
need to try creating the Pivot Table in Access and exporting, just do everything
from Excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export to Excel more than 900,000 records 2
Nesting more than 7 IF statements (Excel 2003) 7
Export Access table to Excel that has more than 65000 records 8
Filtering on more than one field 1
Conditional formatting Excel 2007 4
Create multiple Pivots based on list of parameters 4
If I update Office 2000 is newer version required? 1
HELP! Best way to make statistical table 2

Top