Answered by:
Issue with excel 2003 and 2010

Question
-
I have a user who is experiencing an issue with excel 2003 and excel 2010. The user needs to have both of these programs.
The user uses .xls files daily and has multiple .xls files open all day that she modifies all day long. Throughout the day, she will receive .xlsx files from other users and when she tries to open them, she gets nothing but jibberish. IF she closes all her .xls files and then goes and opens the .xlsx file, it opens just fine in excel 2010.
In short, She cannot open an .xlsx file while she already has an .xls file open.
I've uninstalled and reinstalled office several times. When installing, I install in this order. Office 2003, compatibility pack, excel 2010, REPAIR office 2003. The reason I repair office 2003 is because that's the only way that I know of to get .xls files to default to opening in excel 2003 and not excel 2010.
I've also tried installing excel 2010 in a folder that's separate from office 2003. That doesn't work either.
Other users do not experience this issue and are able to open the .xlsx file while having a .xls file open already. She has the compatibility pack and she has the same software as all the other users. The only difference is that she has a Lenovo T430 while the others have dell desktops and dell laptops. So I duplicated the problem she was having onto another Lenovo T430 laptop and I was able to fixed the issue on this second Lenovo by doing a windows update. BUT, when I did the windows update on the user's laptop, the issue remained.
This does not make any sense to me and is quite frustrating. I found a work around so the user does not need to close out of all her .xls files when trying to open an .xlsx file. But this work around requires 3 extra steps for each .xlsx she receives from others. (I've replaced her laptop twice already for other problems so I don't want to do that again.)
If anyone can help shed some light on this, I would greatly appreciate it!
- Moved by Damon Zheng Monday, May 6, 2013 3:03 PM
Tuesday, April 16, 2013 6:26 PM
Answers
-
Hello exvil,
Sorry for my delayed reply.
This forum is for development issues regarding Excel, such as building document-level customization by VBA, or COM add-ins. For basic usage questions, Microsoft Community is the appropriate forum for discussion: http://answers.microsoft.com/en-us/office/forum/excel
This thread will moved to Off-topic. Your understanding will be appreciated.
Regards,
Damon Zheng
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.- Marked as answer by Just Karl Friday, October 4, 2013 4:01 PM
Monday, May 6, 2013 3:02 PM
All replies
-
I think it is unnecessary to have two versions of Excel on one computer. Excel 2010 can preserve earlier format and in fact opening a file saved as E2003 does not change when opened in E2010. Only saving can affect it. I would uninstall multiple versions to avoid other issues and only run E2010. A warning box will appear if the user tries to save in a different format that what it is opened in.
Additional Microsoft has explicitly warned against having multiple versions installed on machines.
Chris Ward
Tuesday, April 16, 2013 7:21 PM -
The user uses excel 2010 specific for a different purpose called CODA.
This issue is only present on this user but no one else. I wish I can just move everyone to 2010 and be done with it but I can't. 2003 is needed.
Tuesday, April 16, 2013 7:42 PM -
The user uses excel 2010 specific for a different purpose called CODA.
This issue is only present on this user but no one else. I wish I can just move everyone to 2010 and be done with it but I can't. 2003 is needed.
There is no appearant reason for not moving the users to E2010. Could you explain why they cannot? This seems like is would be the solution.Chris Ward
Tuesday, April 16, 2013 7:48 PM -
It's mainly a preference. The users have been using 2003 for 5+ years and 2010 is too different.
Just to clarify, I have 10+ users with both 2003 and 2010 and they do NOT have this issue.
Tuesday, April 16, 2013 8:07 PM -
I don't think I have a solution for your needs. Are you sure the other users are using E2003 vs. E2010?
Usually no matter which version the file is saved in, when you try to open it, it will go to the program most recently fixed. Maybe the users all ran the fix without you knowing?
On the other hand, Do you have the ability to choose default programs? If so maybe both E2003 and E2010 are listed and you can choose there to associate .xls to E2003 and .xlsx to E2010.
I know you mentioned they all had the same software but are they all running the same Operating System with the most recent updates? This may make a difference.
Chris Ward
Tuesday, April 16, 2013 8:36 PM -
Yes I'm sure the other users are using both 2010 and 2003.
The default for .xlsx and .xls are correct. If I don't have a .xls open and I try to open a .xlsx file, it opens just fine in 2010. It's when I already have a .xls file open that I get errors when trying to open a .xlsx file. Even when I try to right click and go to open with and drill down to the excel executable for 2010, if I already have a .xls open then I get the same issue/error(see nothing but jibberish). There's an office11 folder and office14 folder that contain the excel executables. It should be the office14 for excel 2010.
They all have Windows 7. The one with the most current windows updates is the one that is giving me this issue.
Tuesday, April 16, 2013 9:26 PM -
The most current...Can you roll the update back?
Chris Ward
- Proposed as answer by Syswizard Thursday, April 18, 2013 1:27 PM
Wednesday, April 17, 2013 6:28 AM -
Hello exvil,
Sorry for my delayed reply.
This forum is for development issues regarding Excel, such as building document-level customization by VBA, or COM add-ins. For basic usage questions, Microsoft Community is the appropriate forum for discussion: http://answers.microsoft.com/en-us/office/forum/excel
This thread will moved to Off-topic. Your understanding will be appreciated.
Regards,
Damon Zheng
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.- Marked as answer by Just Karl Friday, October 4, 2013 4:01 PM
Monday, May 6, 2013 3:02 PM