Help Issue with Office 2003

D

Dan

I have Office 2003 Standard with the latest patches and I open Powerpoint
2003 and when i try to paste a graph from a excel 2003 sheet to the ppt
presentation it takes a long time to paste and if i click back on the excel
sheet i see this MS Visual Basic error: Error accessing file. Network
connection may have been lost. This only happends on some graphs on excel
pages. I found docs for this error but they refer to access 2000.
 
E

Echo S

Are the Excel files or PPT files on a network drive? If so, try moving the files to your harddrive and then doing the same copy/paste. Do you still get the error message?
 
D

Dan

I tried that and same error. I even tried it on another pc with 1 G of Ram
to see if it was a memory issue and same thing.

Echo S said:
Are the Excel files or PPT files on a network drive? If so, try moving the
files to your harddrive and then doing the same copy/paste. Do you still get
the error message?
--
Echo [MS PPT MVP]
http://www.echosvoice.com
presenter, PPT Live '04
Oct 10-13, San Diego http://www.powerpointlive.com



Dan said:
I have Office 2003 Standard with the latest patches and I open Powerpoint
2003 and when i try to paste a graph from a excel 2003 sheet to the ppt
presentation it takes a long time to paste and if i click back on the excel
sheet i see this MS Visual Basic error: Error accessing file. Network
connection may have been lost. This only happends on some graphs on excel
pages. I found docs for this error but they refer to access 2000.
 
S

Steve Rindsberg

I have Office 2003 Standard with the latest patches and I open Powerpoint
2003 and when i try to paste a graph from a excel 2003 sheet to the ppt
presentation it takes a long time to paste and if i click back on the excel
sheet i see this MS Visual Basic error: Error accessing file. Network
connection may have been lost. This only happends on some graphs on excel
pages. I found docs for this error but they refer to access 2000.

Grasping at straws, but ...

Do you have any addins installed in either PowerPoint or Excel, or is there any
VBA in the spreadsheet you're copying from?

Have you tried Help, Detect and Repair in both PPT and Excel?

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================
 
D

Dan

I dont know if there is VBA in the excell file it looks like normal graphs.
I tried detect and repair. no luck. The wierd thing is that if i try a
different excel file with graphs i have no problems. So i know that the
issue is with the excel file that im using now. I can email you the two
files and you can see the issue yourself if you like. post your email and
ill send you the files.

thanks
 
S

Steve Rindsberg

As long as it's under 2mb or so, sure, why not?

steve atsign pptools dot com

And because I'm getting a lot of spam with virusladen attachments, PLEASE quote
this thread or at least add some reminder text in the body of the email so I
don't see the attachment and bin it. The autopilot's brutal ... <g>


I dont know if there is VBA in the excell file it looks like normal graphs.
I tried detect and repair. no luck. The wierd thing is that if i try a
different excel file with graphs i have no problems. So i know that the
issue is with the excel file that im using now. I can email you the two
files and you can see the issue yourself if you like. post your email and
ill send you the files.

thanks

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================
 
S

Steve Rindsberg

Loose ends tied up here ...

I got the file and when I opened it in Excel, I got a macro security warning. The
file had 6 or 8 apparently empty macro modules. I deleted those, saved a copy of
the XLS and tried copy/pasting from that.

Happy happy. No problems. Whether it was the empty macro modules, or they were
corrupt (like: what were they DOING there otherwise?), or just the Save As doing a
little closet cleaning, but it works. And it worked for Dan too.

Where am I supposed to file the notch? ;-)

As long as it's under 2mb or so, sure, why not?

steve atsign pptools dot com

And because I'm getting a lot of spam with virusladen attachments, PLEASE quote
this thread or at least add some reminder text in the body of the email so I
don't see the attachment and bin it. The autopilot's brutal ... <g>



--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top