Check your other post.

JorgeLMV wrote:

Hi Stephanie,

I'm facing more less the same problem with a workbook that uses lot of
scripts, but I could notice these two facts:
1.- When the file was saved by one PC and then opened by a second one the
problem appeared, the way to deal with was to save the file locally by the
second PC disabling first the macros.
2.- Some times excel was not crashing when it opened the file, but stopping
in one instruction like sheets("Setup").select, this instruction is located
in the workOpen event and it looks like excel was not having opened at that
time this "Setup" sheet.

Did you find other way to deal with this issue ?, thanks for your comments.
--
Regards
Jorge Mendoza V

"Stephanie" wrote:

I've got a very strange issue where on some computers, the workbook opens
just fine, but on others, Excel crashes as soon as it opens and says:
"Microsoft Excel has encountered a problem and needs to close. We are sorry
for the inconvenience."
If I change the order of some of some hidden worksheets on one of the
computers where it does still work, and then reopen it on the ones where it
had crashed, it's okay. While I do have this work-around for the time being,
I'm also seeing some similar issues, and would like to try and figure out the
underlying cause.
We make heavy use of macros, and the third party components from Hyperion
Essbase.

Thanks!
Stephanie

--

Dave Peterson