[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

Unable to open objects on excel 2003

Unable to open objects on excel 2003
0
unisysadmin1
Asked:
unisysadmin1
  • 7
  • 7
  • 2
  • +1
1 Solution
 
FernandoFernandesCommented:
Please send a detailed step by step to get where you're getting, as well as OS version, Office build, etc...

Please help us help you !
0
 
rspahitzCommented:
Just an initial guess...maybe you have macros disabled.
when you first open the workbook, just above the grid is a bar with a warning...select that and enable to see if it helps.
0
 
unisysadmin1Author Commented:
Detailed information:

We have added word, excel, pdf doccuments as an objects in Excel. When we are try to open the embeded doccuments, it does not open. In the formula bar it says "=Embeded("Word Doccument") depending on the type of file you are trying to open...

I have tried to enable and disable Macros.

Application Excel 2003
OS: XP (Office build)

Please help
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
rspahitzCommented:
1) "Document" is misspelled, but I'm guessing that was just when you retyped it
2) How did you get the Embed piece into the formula?  Manually or through a separate process?
3) Are you simply trying to launch Word or open a specific document
4) Are you opposed to using VBA to launch these applications (although they won't be embedded)?
0
 
FernandoFernandesCommented:
and... are you sure that these word documents are still in the same place where they were when these objects were inserted ?
0
 
unisysadmin1Author Commented:
Please excuse my typo.
When I am trying to open the document which is embeded on the excel, it does not open and the formula appears on the formula bar
Word documents are in the same location,  they have not changed
I do not have any access restrictions
0
 
rspahitzCommented:
I don't have access to Excel 2003 anymore but when I try to embed a 2003 word doc into excel 2010, I get this formula:

=EMBED("Word.Document.8","")
0
 
unisysadmin1Author Commented:
Yeah it showing the formula but it is not opening the doccument please help
0
 
rspahitzCommented:
that's not the same formula you have...can you try to add it again and see what happens?
0
 
unisysadmin1Author Commented:
Tried to add multiple times it does not open please help
0
 
rspahitzCommented:
Did you go through the menus?

Insert tab, Text group box, Object

If not that, then we can try to see if VBA can recognize it.
0
 
unisysadmin1Author Commented:
I am afraid I have tried that did not work though
0
 
rspahitzCommented:
Are you able to put pictures or checkboxes?  If so, then the problem is with automation with larger objects.
Does this work on a new workbook?  If not, you may be having some system problems (memory issues.)

How about in Word?  Can you drop an Excel sheet into it?  Maybe your Office suite needs to be re-installed.
0
 
unisysadmin1Author Commented:
It works fine in word..issue is only with excel
0
 
rspahitzCommented:
Did you try to close all Excel documents, open a new blank one, then add any object to see if it will work?  If that fails, then you probably need to uninstall and reinstall Excel.  If it works, then maybe your workbook got corrupted and you need to migrate it to a new one.
0
 
unisysadmin1Author Commented:
Thanks for the solution
0
 
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 7
  • 7
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now