Evening all

I've been using Excel at work for some years now and have now been given a piece of work where I don't think Excel alone will work.

I'm passed a spreadsheet each morning full of raw data. Each sheet contains roughly 1000 lines. I've merged all of the data and I've got 110,000 lines (much more than Excel 2003 can handle!)

What I'm trying to do is create a dynamic dashboard where users can specify parameters such as Start Date and End Date and then create graphs and show the figures to compliment the graphs.

I was originally going to do this by hiding the raw data and having a script build the dashboard each time the parameters were changed.

I'm thinking now that I'll need to have the data in MS Access 2003 (I've done this already) and then somehow have Excel feed from that.

However, the end users (of which there will be about ten) don't have MS Access installed.

I'm constrained by the fact that I don't have the freedom to install any other software/add-ins.

Can anyone think of a way of doing this? Can Excel drag the data from the Access database without having Access installed? And what happens if a user query exceeds 65,536 lines (i.e. they ask for a full years worth of data?)

Thanks in advance for any help!