Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-18-2010, 11:50 AM
erickd erickd is offline issue embedding .xls objects in .ppt file using Office 2010 Windows 7 issue embedding .xls objects in .ppt file using Office 2010 Office 2010 (Version 14.0)
Novice
issue embedding .xls objects in .ppt file using Office 2010
 
Join Date: Nov 2010
Posts: 2
erickd is on a distinguished road
Default issue embedding .xls objects in .ppt file using Office 2010

I am trying to embed Excel .xls file objects that contain VBA code in pages of a .ppt file. Using the menus insert -> object -> from file.

This works fine if I use Powerpoint 2003, but when I try to use Powerpoint 2010 I can get the object inserted but when I try to edit it, I get the following errors:

First in Excel:

"Error accessing file. Network connection may have been lost."


Then in PowerPoint:

"Microsoft PowerPoint can't start the application required to open this object. An error occurred and this featue is no longer functioning properly. Would you like to repair this feature now? "

I click "no" as I know the function is fine.


then another PowerPoint error:

"There isn't enough memory available to read Worksheet."


The files are stored on same disk drive.

My troubleshooting so far:
  1. I have set all macro security for both Excel and Powerpoint 2003 and 2010 to none.
  2. I have checked any boxes that state trust VBA objects.
  3. If I insert the .xls object using PowerPoint 2003 on another system and then re-open the ppt file using 2010, I can then edit the .xls object.
  4. If I convert the .xls file to .xlsm, then insert, it will work fine.
  5. PowerPoint 2010 can insert and edit .xls objects that do not contain VBA code.
  6. I set the references in the Powerpoint VB editor to include Excel object library, no change.
  7. I have installed 2003 on the same system as 2010 (Win 7), and it will not work then, even in the 2003 applications.
  8. I have installed 2010 on the Win XP system and it did not work there either.
  9. I tried dragging and dropping the xls file onto the ppt page, that results in 7 of the 'Error accessing file. . ' messages before it inserts the object.
  10. If I insert the object in 2010, then try to edit the object on the 2003 system, I get the same edit errors.
  11. I can create a new Excel 97-2003 worksheet object, then add a macro to it after it is inserted and it will edit fine. It only errors when inserting from file.
To reproduce the problem, open/create a powerpoint file (can be ppt or pptx). Then insert any xls file that contains some VBA code. (any code will work, I recorded "Hello World"). Insert the file as an Excel 97-2003 worksheet object. After the object is inserted, select to edit the worksheet object. That is when the errors will occur.

Windows 7 system details:
OS - Windows 7 64-bit
Office ver - 2010 Professional Plus
Intel core2duo cpu
4GB ram

Windows XP system details:
OS - Windows XP Pro SP3


Office ver - 3002 Standard Edition SP3
Virtual machine on Oracle VM VirtualBox


Any help is greatly appreciated.


Erick
Reply With Quote
  #2  
Old 12-05-2010, 07:42 AM
erickd erickd is offline issue embedding .xls objects in .ppt file using Office 2010 Windows 7 issue embedding .xls objects in .ppt file using Office 2010 Office 2010 (Version 14.0)
Novice
issue embedding .xls objects in .ppt file using Office 2010
 
Join Date: Nov 2010
Posts: 2
erickd is on a distinguished road
Default

Well a hundred views and no replies. I did not realize this would be such a stumper.

Is there a MVP out there that would be willing to submit this to Microsoft as a bug?

Or, any ideas where I can look next to possibly solving this problem?

Erick
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
License Office Standard 2010 and Home and business 2010 papypaul2 Office 0 11-05-2010 08:55 AM
issue embedding .xls objects in .ppt file using Office 2010 Access to an Office 2010 Excel file over network lohith.korp Office 2 09-27-2010 08:32 AM
Installing Office 2010 - Word issue David Kilner Word 0 09-21-2010 06:39 PM
Office 2010 File Formats ellisgj@gmail.com Office 1 04-30-2010 10:22 AM
Group objects in Office Alfie Drawing and Graphics 3 04-16-2009 10:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft