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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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
[email protected]
http://www.bblisa.org/mailman/listinfo/bblisa
_______________________________________________
bblisa mailing list
[email protected]
http://www.bblisa.org/mailman/listinfo/bblisa
_______________________________________________
bblisa mailing list
[email protected]
http://www.bblisa.org/mailman/listinfo/bblisa
