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, but isn't sure if its still possible. There is some info about excel and recalculation here: http://msdn2.microsoft.com/en-us/library/bb687891.aspx and more, if you google search it. Might not be right, but could be worth further investigation. Eric On Thu, Mar 27, 2008 at 7:23 PM, Edward Ned Harvey <[EMAIL PROTECTED]> wrote: > 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
