Do any newer versions of Excel (2003 or XP) offer more than 65,53.
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...... |
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. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "SAPDataWizard" wrote in message ... 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...... --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004 |
All times are GMT +1. The time now is 07:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com