Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can Excel load data of volume 50 mb and analyse also by adding 25 mb more
Dear Madam / Sir
I would clarify few points mentioned below regarding the development of MIS Application using Microsoft Excel 2000 or above version Is it stable while trying to retrieve data of volume say to start with 40 - 50mb per month and might increase into 75 - 100 mb in 2 years into excel formated sheet for analyzing While you are analyzing this data of June 2004 say 50Mb, user wants to compare last year data of the same month June 2003 either you can open a separate excel sheet for June 2003, in this case two excel files of 50mb size shall be opened (or) you can dynamically insert a column on the exiting sheet of the user viewing and the size of the existing sheet might go from 50mb to 70 mb maximum Is this the best way to do it, since users are more comfortable with Excel and the volume of data can't be decreased ?? (or) better to use crystal reports or any other tool available to take care of this as well graph display is also required Hope you could understand my point and try to help me out, how to go about it? Thanks With warm regards Bala SK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need my formula to analyse numerical and text data | Excel Discussion (Misc queries) | |||
I need to analyse data across a number of filtered columns | New Users to Excel | |||
how do you use a chisquare function to analyse data | Excel Worksheet Functions | |||
how do I analyse two spreadsheets for missing data? | Excel Discussion (Misc queries) | |||
How do i analyse visible rows only in excel? | Excel Worksheet Functions |