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

[David Allan]

I'm also not an Excel expert, but I know that in the past it's been 
possible to cut down the size of MS Office files and speed up their 
opening by doing a 'Save As'.  I believe it had something to do with MS 
saving changes as a series of diffs or something like that causing the 
file to grow until a fresh save was done.  OTOH, that may all be ancient 
history; I haven't used Windows much lately, but it would be easy to try.

I also like Tal's suggestion of moving to a DB.

Dave


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 then use the database.
>
> Tal
>
>
> -----Original Message-----
> From: bblisa-bounces at bblisa.org [mailto:bblisa-bounces at bblisa.org] On Behalf Of Edward Ned Harvey
> Sent: Thursday, March 27, 2008 7:24 PM
> To: 'L-bblisa'
> Subject: [BBLISA] Know any (real) MS Excel experts?
>
> Hey, I'm looking for a rare breed of human being.  The problem is simple to describe - I know a location where they have a very important huge spreadsheet.  Something like 50 megs, and when they open it up, it might take 45 minutes to open.
>
> The question is whether there is something wrong, and something that can be done to improve it, short of getting rid of the spreadsheet file.
>
> I know this is a weird one...  Lemme know if you know anyone who might be able to do that, ok?
>
> Thanks, ttyl...
>
> _______________________________________________
> bblisa mailing list
> bblisa at bblisa.org
> http://www.bblisa.org/mailman/listinfo/bblisa
>
> _______________________________________________
> bblisa mailing list
> bblisa at bblisa.org
> http://www.bblisa.org/mailman/listinfo/bblisa
>