Solved

Can't open embedded objects (word files) in Excel 2003 when generated in Excel 2007

Posted on 2009-07-07
4
1,374 Views
Last Modified: 2012-06-27
We have a few users at my work who have been experiencing this problem.

They use Office 2003 and receive a document from someone using Office 2007. They HAVE downloaded the compatibility pack and are able to open the 07 documents fine, IE: a word doc opens fine.

However an excel spreadsheet that has an embedded object, such as a Word document does NOT open. Well the Spreadsheet itself opens up, then you see the word doc icon and clicking on it, it pops up with a message box saying "covert file" and gives options for converting it to a different format, rich text, html, works, etc. Whatever the user clicks on the document comes up as scrambled unreadable gibberish. If you choose to cancel the 'convert file' window you get the message 'cannot open source application'.

Does anyone have any ideas?

Thanks!
0
Comment
Question by:MikeC7
  • 2
  • 2
4 Comments
 
LVL 37

Accepted Solution

by:
Joanne M. Orzech earned 500 total points
ID: 24824982
Since you've received no response, I did a little research and found the following:

"Unfortunately, the Compatibility Pack does have limitations. One major limitation is that the Compatibility Pack is unable to open and view embedded Office Open XML objects. Users who attempt to open an embedded Office Open XML using older versions of Office will be unable to do so and will receive a generic failure error. As mentioned in the following KB article, http://support.microsoft.com/kb/932121, there is no work around these users can perform without opening these files in Office 2007."

http://embeddedoleextractor.codeplex.com/

http://support.microsoft.com/default.aspx/kb/932121
0
 

Author Comment

by:MikeC7
ID: 24844031
Yeah I think you may be right. I was unaware the compatibility pack wouldn't work for things like this. Thanks so much for your time!
0
 

Author Closing Comment

by:MikeC7
ID: 31600633
I think you may be correct that this is just the same problem referenced. Thanks a lot for taking the time to dig that up for me!! I guess we will just have to buy some 07 licenses.
0
 
LVL 37

Expert Comment

by:Joanne M. Orzech
ID: 24849777
:)  So very pleased I was able to help you!  Thank you very much MikeC7.

Joanne Orzech
MS Word MVP
EE Zone Advisor
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now