L
LV System
I got the oddest problem. The system is Windows XP Pro with Office XP Pro.
When an Excel file is double clicked, Excel opens up but it contains no
worksheet, it is grey.
If Excel is opened and then file is opened then the work sheet is OK.
In addition, a set of macros (that work on another system, same OS, same
Office) that
are in Word, and supposed to open an excel worksheet and pull info from it,
also does not work.
Word gives message "Waiting for Excell to Accept DDE command". At this point
you can wait forever and nothing happans.
I suspect the 2 problems are related.
I have doen following:
do a "Repair" on Office. This was successful only after I installed Mdac.
Deleted the XLS association and let windows re-creatre it by choosing Excel
when
doublclicking on a worksheet. Same problem.
I also found that the normal.dot file of Word was bad, the above mentioned
macros are
on buttons on a custom toolbar. When I tried to delete the toolbar (so that
I can
remake the whole macro gobbledi-gook over), after the deletion the toolbar
came back
when Word was opened again! This was due to the bad normal.dot. After
deleting it
and letting Word create a new one, any toolbars I made could be deleted
without any problem.
Is there a "normal.dot" file for Excel ?
I still cann't quite tell if me problem is Excel or Windows Explorer.
I compared some registry items between the working and non-working systems
that relate to .xls, but could not find the problem. The registry is HUGE,
99.9Megabytes!
I'd hate to try to compare the whole thing.
Any help would be appreciated.
When an Excel file is double clicked, Excel opens up but it contains no
worksheet, it is grey.
If Excel is opened and then file is opened then the work sheet is OK.
In addition, a set of macros (that work on another system, same OS, same
Office) that
are in Word, and supposed to open an excel worksheet and pull info from it,
also does not work.
Word gives message "Waiting for Excell to Accept DDE command". At this point
you can wait forever and nothing happans.
I suspect the 2 problems are related.
I have doen following:
do a "Repair" on Office. This was successful only after I installed Mdac.
Deleted the XLS association and let windows re-creatre it by choosing Excel
when
doublclicking on a worksheet. Same problem.
I also found that the normal.dot file of Word was bad, the above mentioned
macros are
on buttons on a custom toolbar. When I tried to delete the toolbar (so that
I can
remake the whole macro gobbledi-gook over), after the deletion the toolbar
came back
when Word was opened again! This was due to the bad normal.dot. After
deleting it
and letting Word create a new one, any toolbars I made could be deleted
without any problem.
Is there a "normal.dot" file for Excel ?
I still cann't quite tell if me problem is Excel or Windows Explorer.
I compared some registry items between the working and non-working systems
that relate to .xls, but could not find the problem. The registry is HUGE,
99.9Megabytes!
I'd hate to try to compare the whole thing.
Any help would be appreciated.