This is hypothetical of course, because no sane person would ever do this
:-)).

Assuming that Excel is still standing after this, I don't think you would
encounter any particular problems. But if you pass the workbook to anyone
else, and they don't have a particular file referred to, they might well get
problems.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alan" wrote in message
...

Hi All,

In the spirit of curiosity, I am just wondering what would happen if I
were to go and set every single reference in excel under tools -
references?

I assume it would mean that every single object model would become
available (early bound?), but what would be the downside?

Would my PC grind to a crawl and / or fail to ever open excel again?

I could just try it, but I don't want to have to reinstall Excel,
Office, or even Windows if it goes badly wrong!

Just to be clear, I don't have any particular need to do this - I am
just wondering.

Thanks,

Alan.

--
The views expressed are my own, and not those of my employer or anyone
else associated with me.

My current valid email address is:



This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address