Visio 2000 broke Excel (Office XP Pro)
 

One of our users has Win XP Pro with Office XP Pro. He
upgraded from Visio Standard 5 to Visio 2000 today and
since doing so has had problems with his Office suite.
When he tries to open Excel he gets the warning "Compile
error in hidden module: this workbook". He can OK this
message and use Excel but Access does not work at all (no
messages). Outlook and Word seem to be fine so it seems
to be a problem with VBA.

I have trawled through the MS knowledge base and cannot
find a match for this issue. A lot of similar things but
the fixes for those did not work either.
I can find a KB article on the opposite of this problem -
Visio 2000 stops working when upgrade Office to XP, but
can find nothing on Office XP stops working when Visio
upgraded to 2000.
Another user upgraded to Visio 2000 and has had no
problems but he uses Office 2000.

The user that is using Office XP has tried removing &
reinstalling office. Then tried the same with Visio.
Then removed both office and visio, reinstalled visio
first (in case it removes something from Office) then
installed office. None of these actions worked.

Does anyone know what causes this? Perhaps you know of a
KB article on the matter that I did not find? Or can you
suggest a service pack for OfficeXP/Visio2000?

Thanks,
Kirsten

Visio 2000 broke Excel (Office XP Pro)
 

The compile error when Excel starts suggests that a workbook is opening with
Excel automatically that has a problem. Look in the user's XLSTART folders
for any workbooks you do not want starting automatically. Also anything
selected under Tools, Add-ins. If the user has made an entry under Tools,
Options, General, "At startup open all files in" check the files in that
location too.
--
Jim Rech
Excel MVP