Results 1 to 6 of 6
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The following issue was raised:

    Finance have excel files that contain drawing objects.

    The file was created in Excel XP.

    When the file opens in Excel XP - view on screen ok & prints ok

    When the same file opens in Excel2007, views on screen ok. on print the drawing objects move.

    see attachment

    Is this due to compatiablity?

    Do you know why the drawings jump around on print?

    many thanks

    diana
    Attached Files Attached Files

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    Please attach a file in Excel format. A PDF doesn't show us what we need to see.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Apologies Catherine for the delay.

    pls find excel file attached.

    I had a look to see if a theres a related excel compatibility in XP or 2007 but couldnt find one

    diana
    Attached Images Attached Images
    Attached Files Attached Files

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    I tested printing the file on Excel 2007. No movement.
    I checked, the drawing objects - they are set to move and size with the cells (which is what I would have recommended).
    So, I'm thinking that different print drivers are the problem. I assume that different machines are involved here?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    New Lounger
    Join Date
    Dec 2009
    Location
    Woodbury, GA
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I too successfully printed with no movement of the drawing objects. I used a Brother Color Laser printer and achieved the output expected.

    Because both Catharine and I did not experience the problem that you are seeing, I would suspect your printer driver's interaction with Excel is the problem. See if your printer has a new driver available, or re-install your current driver to see if you can find a resolution.



  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts
    thankyou yes your both right.

    Were in the process of upgrading to Office 2007 so initially I thought it was compatiability issues between excel XP & 2007.

    We have two printer vendors on the floors.

    Ive tested by printing to both different printers and get different results.

    On the canon printers the drawing objects move.
    Tested by printing to a lexmakr printer - and prints correctly.

    thank you again

    diana

Posting Permissions

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