I think we have pushed Excel too far. There is an ongoing issue with excel
being rather slow, but it is only slow for certain people on certain files.
The IT dept and Planning have been head butting about this for some time, and
I am wanting some 3rd party perspective. Our head of planning has been
writing increasingly large excel sheets. Several in the 80-120mb area, with
multiple worksheets numbering in the 50-60 thoughsand + area, with an average
of 10-14 fomulae per worksheet, and each formula is extended the entire
heighth of the worksheet and the formulae themselfs are quite sizeable. This
is combined with many large pivot tables and complicated lookups and offset
lookups going to other files of comparable size and complexity. My question
is this, should this be migrated over to access? I figure it should be since
Access is designed for this kind of data base volume, and as far as I can
tell Excel seems to have reached and passed what it can process effeciently.
He frequelty have upwards of a 1/2 gig open in excel files at once, from 4-6
files, and when he is on and working, everyone else on that terminal (Citrix)
server is feelig the strain (and said server is new and top of the line) and
everyone in that yard sharing the T1 is also feeling the effects.
What do you guys think?