Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Dec 2001
    Location
    Cromwell, Connecticut, USA
    Posts
    40
    Thanks
    2
    Thanked 2 Times in 2 Posts

    Copied Worksheet Looks Different (Excel 2003 SP2)

    Has anyone seen this one before?

    All PC's in our office have the same OS (Win XP SP2) & Office (2003 SP2) configurations. The problem only occurs on one desktop but it is the primary one used for this type of Excel use.

    When using this specific desktop PC with a CRT monitor, anytime a worksheet is copied into a new workbook and saved, it is an exact copy of the original. The new worksheet can be viewed on any PC with a CRT monitor and viewed as an exact copy (3 different vendors of PC hardware, different res., etc.).

    When the same files are viewed on a PC with a flat panel monitor the original looks fine but the copied worksheet is about 80% as wide as the original. The whole spreadsheet looks squished to the left. A small logo graphic is also distorted in this manner (see attached).

    I can see that the column widths are reduced in the "squished" copy (why? I didn't touch it) but why the graphic? This happens whether I perform the copy manually or programatically & I would like to track down why it is happening. Any thoughts appreciated!

    John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copied Worksheet Looks Different (Excel 2003 SP2)

    I apologize for the lack of replies. This one has me stumped - I don't have the slightest idea what causes this, and I haven't been able to find anything relevant about it.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copied Worksheet Looks Different (Excel 2003 S

    Hi Kamski

    Like Hans I have slept on this overnight. The only thing that strikes me is if the miscreant PC has some kind of template in its Start up folder. Have a look in Cocuments and Settings[USERNAME]Application DataMicrosoftExcelXLSTART and see if there are any excel workbooks in there.

    Yours (clutching at straws)
    Jerry

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copied Worksheet Looks Different (Excel 2003 SP2)

    I too do not have any good thoughts on what might cause this. One remote possibility would be to check to see if there are any updates for the video driver on that machine. You might also check for updates to the printer driver for the default printer as that can also sometimes affect how Excel displays data on the screen (at least in some older versions).
    Legare Coleman

  5. #5
    Lounger
    Join Date
    Dec 2001
    Location
    Cromwell, Connecticut, USA
    Posts
    40
    Thanks
    2
    Thanked 2 Times in 2 Posts

    Re: Copied Worksheet Looks Different (Excel 2003 S

    Jerry,

    There use to be a file in the Excel startup folder that was used as an intermediate between some Access & Excel data on this machine. It will take me several days to verify since I'm out of the office for the holidays but I will let you know what I find.

    Thanks,
    John

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copied Worksheet Looks Different (Excel 2003 S

    <img src=/S/cool.gif border=0 alt=cool width=15 height=15> Have a great Christmas break
    Jerry

Posting Permissions

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