RE: [BBLISA] Know any (real) MS Excel experts?

2008-03-28 Thread Scott R. Ehrlich
Have you tried the [EMAIL PROTECTED] list? They may have some local leads. I presume this is for Excel for Windows, and not the Mac? Scott On Thu, 27 Mar 2008, Tal Cohen wrote: Not an Excel expert, but I would write a perl script that migrates the excel data into a MySQL database and

Re: [BBLISA] Know any (real) MS Excel experts?

2008-03-28 Thread Eric Smith
I forwarded this on to a friend who knows more Excel than me (not that hard) He pointed out that Excel does a Recalc on open. He guessed that this might be why it's taking so long to open, assuming there is a lot of calculations to do. He though there was a way to turn this off at one point,

Re: [BBLISA] Know any (real) MS Excel experts?

2008-03-28 Thread Sean OMeara
Isn't this what MS Access is for? If I recall correctly, Excel should have built in ODBC-fu for letting spreadsheet users directly manipulate the contents of a database. I'm not sure how portable the spreadsheet is after that, but if it's already at 50 megs, chances are they're not exactly