Capacity of Excel File

Hi Friends,

Now I am building an excel file to include all the financial data of my company from 2003 to date, the file size is 111700 kb and I reached row number 822000, in future when I add the data of Jun-9 to Dec-09 the file will grow beyond the excel capacity of 1 million + rows; can you please advise if I have to switch to access or is there any upcoming version of excel that can hold the whole data in one file.

I am using excel’s pivot tables for analysis and charting, is there any other application that can provide the same or better analytical tools than excel?

Many thanks

Hi Stormseed,

All data are text, the pivot is in the same file, no macros, formulae,colours, borders etc... are used, the actual size is 117000 kb 822000 rows and 16 coloumns

Thanks in advance for your help

Best regards

what you can do is create the database in access and query it from excel this way you wont have an issue with the rows and size of the database and you'll have Excel as your userend interface.

Hi Anujsh07

Can you please put me in the first step of how to use access and excel , I mean how to query the data in access from excel

Thanks in advance