Presenting large Excel spreadseet on Internet

I'm new to Excel, having used Approach for years. I now have an Excel spreadsheet of some 15,000 rows by 10 columns. Some fields of 10 characters and some memo fields.

I am trying to find a simple way to present this large spreadsheet to the public, in a fast way, both for myself and for the viewers with dial-up.

It is a re-constructed roster of an American Infantry Division. There is a lot of interest, but I can't figure out how to show it all. If I simply upload the XLS, it takes a long time to load. And when loaded takes a long time to scroll down to the desired line.

I've looked at some software that might help, but can't afford any of them.
Any ideas most welcome. An example at www.IndianaMilitary.org Select "30th Div" in top row then "Roster" and "117th" in lefthand drop-down menu.

Thanks

You could try Google Documents. It allows you to load spreadsheets and allow other users by invite.

I tried Google, but about 1/3rd the way thru I get an error and that is the end of that, with no explanations. PDF would look good, but just too big. This is mainly for WW2 Vets and many only have dial-up.

Seems there should be some simple way to create a searchable database. I know you can buy them, but that is out of the question.

Thanks for the ideas.

Have you tried saving the files as html and posting the html to your site. I use this method to share large amounts of data and it works quite well. You can take the sheet a step further by enabling auto filters or even presenting the data in a pivot table.

I tried a couple of options in Excel, and can't tell you which did what now. But one that looked promising, had a box checked "interactive". Looked great on my local machine. But when I posted to the Internet, and had others look, they all got a message that they needed to download some MS software. They did and installed, but continued to get the message. So since it is for WW2 Vets that may not have much computer savy (like me, evidently), it was just too complicated.

I took all the data and put it into my old IBM Lotus Approach, which I really prefer, having used it for many years at work. It will publish as HTML, but only with approximately 20 or so lines of data per page, followed by links to the next page. One unit ended up with 130 pages, and there is no way to go directly to a name or an alpha character (like all B's). So that is easy but has drawbacks.

Thanks for the ideas.

West

Too bad. I've seen it prompt to enable Active X when opening the html file locally, but not when viewing a true published version. Good luck.

BTW - is your spreadsheet just a member listing or does it include all of the background text/paragraphs like in the example 117th example you referenced?

The pages to display on the Internet will be as large as the 117th, plus at least one and maybe two more columns.

15,000 rows. A lot of info to show. Wish I could afford some software that is interactive and allow the viewer to search for a name. But can't. I found some that will allow it for $30, but it has the viewers looking on MY computer. I would not especially mind that, but I only hae a slow satellite hook-up, and the PC could never be turned off.

I have "FREEFIND" on the site, and it works well. I am hoping that given time it might search out a name. But that would be a big order for free software.

Thanks

Jim West