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