+ Reply to Thread
Results 1 to 3 of 3

Graphics Move After Saving and Closing

  1. #1
    Registered User
    Join Date
    02-09-2012
    Location
    Decatur, AL
    MS-Off Ver
    Excel 2010
    Posts
    2

    Graphics Move After Saving and Closing

    I am creating a calculation package for the engineering firm I work for. The calculations come from a standard, and I like to include the equations I use from the standard in the spreadsheet. I use Microsoft Equation 3.0 to create the equations and it enters them as a graphic on the spreadsheet. Also included on the spreadsheet are drop down boxes, selection bubbles, and a company logo graphic. I place these graphics, boxes, and bubbles in the positions I want them in the correct size. They are in these positions when I save the document. However, they often are out of place when I reopen the file, always shifted up and to the right, sometimes smaller. It doesn't do it all of the time, but it happens enough to get mad. I've spent hours reformatting entire workbooks because of this, time that our clients pay for sometimes. I have had two computers now that it does it on, so it's not a computer specific deal. I can't find anyone else who has this problem. Any help with this would be greatly appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,077

    Re: Graphics Move After Saving and Closing

    I'm not sure whether this will work, but in the properties of the graphic select the option <Don't move or size with cells>.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Registered User
    Join Date
    02-09-2012
    Location
    Decatur, AL
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Graphics Move After Saving and Closing

    I have started to do so, so far with no problems. I have also selected <Lock aspect ratio>. We'll see if it continues to work. Thanks!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1