Hello,
I have a coworker that uses excel pretty much exclusively all day because he is one of the accountants. He recently got a new computer and at first put Office 2007 Standard on it but was not used to it so he put Office 2003 Standard on it. He said when he has different excel workbooks open that when you click window up at the top that it is supposed to show all of the open excel files/workbooks. He noticed that its not doing that (ie. he can have a few different workbooks open and they dont all show up when you click on window in the top menu. I have noticed that on my computer, even if I have multiple instances of excel open that in task manager there is only one excel process; but on his computer if he has a few different workbooks open there are a few different excel.exe processes open. I uninstalled both versions for him and reinstalled 2003, but he said the problem persists. Can anyone offer any advice that might steer me in the right direction to help him?
Not sure this will help, using Excel 2000, on XP.
If I open the first instance of Excel I will have only one process running, now if I open a second workbook from within this first Excel workbook, I will still have only one process running. Regardless of how many workbooks I open from within the first instance, I get only one process.
The only way I can get another Excel process to run, is if I then go to the START > Programs > Microsoft Office > Excel and explicitly start another instance.
Having both 2003 & 2007 running at the same time, would probably cause two separate process to run.
Someplace along the line I would guess that a registry entry got flummoxed.
Try running a Detect & Repair, and see if that help.
MIKE
http://www.skeptic.com/
The reason that only one Workbook appears in the ‘Windows’ Menu item is likely that each workbook is opening in a new instance of Excel, rather than being opened by the currently running version of Excel.
This article at lytebyte discusses the settings to change Excel’s actions when opening files – single instance or multiple instances.
Also how applications are used to open files is controlled from the ‘Tools’ – ‘Folder Options’ – ‘File Types’ – ‘Advanced’ menu in Windows Explorer.
Under XLS and the ‘Open’ item (click edit) you will see DDE commands – see if the current setting matches settings on another PC that is working ‘as expected’. On my PC ‘Open’ has DDE checked, and ‘DDE Message:’ [open(“%1”)]
and Excel under ‘Application:’ and System under ‘Topic:’
Regards