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

[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, 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
<bblisa2 at nedharvey.com> 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...
>