A peculiar problem

[Patrick Molloy]

If you increase the security rating, then open the
workbook with macros disabled, does it open / close
faster?

I was thinking that you may have to auto_open auto_close
code that might be looping

Patrick Molloy
Microsoft Excel MVP

 

[Ignatius]

Thanks for the suggestion but I tried that. I also set
it to manual recalculation to see if custom formulas were
taking a long time. I stripped code and formulas out I
repaired office then uninstalled it and reinstalled it.
I removed all temporary files and ran a virus check. I
defraged my drive. I stopped short of throwing it out of
the window but I still have the bug and it is machine
and file dependent. I have gone from being frustrated to
just curious. I don't want this one to jump out again
when the time pressure is on.