×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Problem with images

Problem with images

Problem with images

(OP)
We use Excel 2013

We have files for GM that we need to use the snipping tool to create an image from another program, then paste it into a particular excel file. A file will usually end up with anywhere from 1 to 20 pictures pasted into the sheet.

For some reason excel does not like these images. If I forget to change to a different tab and leave it on the pictures tab, then switch over to another program, usually NX as that is where we create the snipped pictures, when I return to excel it will lag extremely bad. Lately it is a 50-50 chance of it kicking me out of excel all together.

While I am working in the images tab, it lags quite a bit even if I dont bring another program to the front. I will select a picture and it might take upwards of 10 or 20 seconds before that picture will actually start moving. As annoying as that is, I can live with that. What I cannot deal with is Excel locking up every time I bring another program to the front and return to excel. I am certain it is the pictures I paste into it because if I switch tabs to another without pictures, then go make the snippet, and then return to excel and switch to the pictures tab to paste the picture, it never locks up. Only that is really hard to get used to when it is the only program that has that demand.

Has anyone else dealt with this problem or is it possible our excel is not installed right? The thing is, it is not just my computer. Others here are having the same issue.

Any help with this is appreciated.



RE: Problem with images

(OP)
Unfortunately I am not allowed to give out GM documents. Give me a few and I will try and create something I can send.

RE: Problem with images

(OP)
So I created a test file in excel. I threw a bunch of meaningless crap on one tab. Threw several snippets of pictures just of this page on the other tab. It seemed to be working fine still and I was wondering if it was because it is still only 80KB in size. The GM files we use are over 3,000KB. I started typing in here to ask a question and before submitting, I went back to the excel file I had created and it kicked me out. So I also now know the size of the file is not a problem, though I didnt think 3,000KB was much to begin with.

I am attaching the test file I created. Keep in mind. that if you leave it on the "Design" tab, there likely wont be any problems. If you leave it on the "Pictures" tab, then go and work on other things for a couple minutes and return to it, that is when it should have a problem. If it doesnt for you, then it means either we have a setting causing problems, or a problematic installation, is my guess.

Thanks for the help.

RE: Problem with images

Save early, save often?

Do a Google search on "excel crashes on pasting pictures" to see if any suggestions seem to cover your case. I'd copy/paste, but there look to be a huge number of causes/complaints.

RE: Problem with images

Hi, Ken,

I don't know why this happens. I know it has happened to me in a variety of settings over the past decades.

I'd use Events in VBA.

In the Worksheet_Deactivate event of the Pictures sheet I'd use...

CODE

Private Sub Workbook_Deactivate() 
 Application.CutCopyMode = False
End Sub 

You may also need to clear the Windows clipboard.

CODE

Option Explicit

Public Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long
Public Declare Function EmptyClipboard Lib "user32" () As Long
Public Declare Function CloseClipboard Lib "user32" () As Long

Public Function ClearClipboard()
  OpenClipboard (0&)
  EmptyClipboard
  CloseClipboard
End Function 

The just run ClearClipboard in the Deactivate event along with the other code.

Please post back with your success or lack thereof.

Oh, yes and add a Save as well!!!

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Problem with images

This may also work

CODE

Option Explicit

Sub ClearClipboard()
    Dim oData   As Object   'object to use the clipboard
    
    Set oData = CreateObject("New:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")
    oData.SetText Text:=Empty
    oData.PutInClipboard
    Set oData = Nothing
End Sub


Private Sub Workbook_Deactivate()
    Application.CutCopyMode = False
    
    ClearClipboard
    
    Application.DisplayAlerts = False
    ThisWorkbook.Save
    Application.DisplayAlerts = True
End Sub 


Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Problem with images

Using the worksheet_deactivate event as suggested by Skip is not something I've ever done, but it sounds like a great idea, especially the ClearClipboard part.

I'll be interested to hear if it solves the problem.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Problem with images

I didn't have any issues with the test file. Is there any VBA code running already on the file that is causing issues?

RE: Problem with images

(OP)
Thank you everyone for the help. I apologize for not replying. For some reason Eng-Tips doesnt email me anymore when I get a response.

Strangely I sort of found what the problem is.

At the bottom right corner of excel there are three buttons for view settings just left of the zoom. GM's Ergo sheets are saved so the "Page Layout" option is selected. When it is on page layout, it causes all of our stuff to lag here if there are images involved. However, once I switched it to "Normal" I have not had a problem in three days of working with these files.

You will have to forgive me for not trying those Skip. These being GM files, and because multiple people here are having the problem, I wouldn't be able to fix this overall this way. That I can see at least. And I dont want to alter GM's files other than what I was showed to do to past images and fill out the cells that are not locked on other tabs.

I dont understand why the Page Layout setting messes us up with Images, but at least now we can work without the hassle. lol

RE: Problem with images

Kenja824,

What do you mean by the expression "GM" files. I could not find a context in your posts. I assume it is a general term for proprietary files.

Jim


RE: Problem with images

GM is a niche automobile maker.

RE: Problem with images

Thank you 3DDave for the answer. I went back and clicked on Kenja824's name and see they are from Michigan so GM meaning General Motors makes sense. However contextually I couldn't make that leap.

Jim

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Resources

Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close