+ Reply to Thread
Results 1 to 5 of 5

Exported table comes out differently on two PCs... PLEASE help I'm desperate

  1. #1
    Forum Contributor
    Join Date
    03-16-2007
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2007
    Posts
    202

    Exported table comes out differently on two PCs... PLEASE help I'm desperate

    Hello,
    Me and my colleague use Excel each one on its own PC. When we open the same file on them, export a table, and import it into Adobe Illustrator, the row height comes out slightly different on each PC so that the whole table differs in up to 1 cm in height.
    Both PCs have the Windows, Excel and Illustrator versions installed.
    We have tried all options with exporting as seen on screen, as seen when printed etc. We have set all excel options exactly identically.
    We've tried it all and still the table comes out different. This happens with ALL files.
    The screen resolution is the same on both PCs, but the monitors we use are of different sizes (don't know if this has something to do) so the area visible on screen with the same zoom level is different.
    I have also noticed that the Page Break Preview doesn't sets the page break lines on the same places on both PC's. But adjusting them manually doesn't fix the problem.
    How can we fool Excel into thinking we have the same sized monitor, if this is causing the problem?
    If not, what else can it be?
    Please help me with any ideas, I'm going crazy!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,379

    Re: Exported table comes out differently on two PCs... PLEASE help I'm desperate

    Are you using the same printer?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    03-16-2007
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2007
    Posts
    202

    Re: Exported table comes out differently on two PCs... PLEASE help I'm desperate

    No, we're using different printers...
    But we tried setting "Microsoft Print to PDF" as printer on both PCs and it didn't help either...

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,379

    Re: Exported table comes out differently on two PCs... PLEASE help I'm desperate

    I think (not 100% sure) that the page settings are taken from the default printer margin settings, so even if you are printing to a PDF driver, this may be the underlying issue.

  5. #5
    Forum Contributor
    Join Date
    03-16-2007
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2007
    Posts
    202

    Re: Exported table comes out differently on two PCs... PLEASE help I'm desperate

    AliGW, thanks a lot for your help.
    No, it wasn't the printer. We tried everything snd finally we found it: in Settings > System > Display there is a Windows setting called "Scale and Layout" which was on one PC set to 100%, and on another on 125% (because of a bigger monitor). When this value is different, something happens to the size of the exported grids. When we set both on 125% the problem was fixed.
    Thanks again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create a new table (or matrix) from an exported set of data from a website.
    By dherrero in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2014, 11:19 AM
  2. Formula or Vb.Net for condensing a table exported from AutoCad
    By cncah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-26-2014, 10:17 PM
  3. Columns Shaded Differently Within Table
    By Gard5096 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2013, 06:49 PM
  4. Hyperlinks in Excel Table exported to Sharepoint
    By nasz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2011, 01:05 AM
  5. [SOLVED] Pivot Table Calculating totals differently
    By esparzaone in forum Excel General
    Replies: 1
    Last Post: 02-21-2006, 09:01 PM
  6. Replies: 1
    Last Post: 03-25-2005, 01:06 PM
  7. [SOLVED] Word table exported to Excel
    By rwSRA in forum Excel General
    Replies: 1
    Last Post: 03-24-2005, 05:06 PM

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