Solved

Excel 2010 - Pixcel Size Differences

Posted on 2013-06-05
12
117 Views
Last Modified: 2013-08-31
Okay here is probably the strangest issue I have seen.  If you go to View>Page Layout and you shrink any cell to be .25" it will be 24 pixels.  That is the way it is for 99% of our users.  There is one user that when you shrink it to .25" it is 30 Pixels.  This is causing issues where the columns aren't being spaced correctly and causing uploads to fail.

I fixed the issue for a bit by removing her profile on the computer and re-creating it.  Also if I log in to the computer as anyone else it will be just fine.  The issues is something she is doing/opening is causing this issue.

ANY help would be very much appreciated!  Thanks again.
0
Comment
Question by:Kent Fichtner
  • 6
  • 5
12 Comments
 
LVL 35

Expert Comment

by:[ fanpages ]
Comment Utility
Hi,

What is the pixel size of the shrunken cell if that one user is logged-on to any other PC?

The same as on the normal PC, or the same as everybody else?

PS. I think you may have to elaborate on this statement:

This is causing issues where the columns aren't being spaced correctly and causing uploads to fail.

BFN,

fp.
0
 
LVL 4

Author Comment

by:Kent Fichtner
Comment Utility
When she logs in to another computer and loads Excel, it is "normal" (.25" = 24 pixels).

What I mean by the upload is:  She is making a PRN file to upload in to our internal system.

The issue this is causing is this, the spaces between the columns when loading the PRN file in note pad is off then what is expected and it is causing the upload to fail.
0
 
LVL 35

Expert Comment

by:[ fanpages ]
Comment Utility
OK, thanks.

So the issue is with one user on one particular PC?

Yet, other users on that PC are not experiencing the same problem.


Short of checking that every component of the PC, screen(s), mouse, keyboard, & so on are identical, & that the environment is exactly the same (including all operating system drivers & Microsoft Office patches/fixes/revision/versions); a suggestion:

That one user & one colleague could swap PCs.
0
 
LVL 4

Author Comment

by:Kent Fichtner
Comment Utility
I like the idea of changing the computers, and that would work for a bit.  But it would most likely happen again on the different computer.  I am not sure the cause of it, but something she is doing/opening is screwing this up.
0
 
LVL 35

Expert Comment

by:[ fanpages ]
Comment Utility
Are there any files that one user opens/updates/saves that differ from the workload of any other user?

If you have deleted & re-created the user profile, then I think it is fair to assume that whatever is happening to cause the difference is either a user-configurable setting that the one user changes from the default settings or, as you said, the ramifications of a different task compared with the colleagues.

Did you start with a new profile, or clone one from a colleague?

We could look at writing some Visual Basic for Applications code that exports the data from the worksheet in the required format that mimics the PRN file currently being generated, so that every user has the same output regardless of their individual profile/configuration, but that may be overkill.

Then again, it may be the best/only option.

You could, though, start again with a new profile, & then log the usage of all Microsoft Excel workbooks for that one user (either with a bespoke process, or using something like the Journal facility within Microsoft Outlook).

If every other user has logging of this nature active too, over, say, one week, the files used could then be reviewed/compared to see if there were any notable differences.

If no differences are noted, then it must be something the individual user is changing within their environment.

I am guessing you have checked the printer driver/set-up against those used by the colleagues.
0
 
LVL 4

Author Comment

by:Kent Fichtner
Comment Utility
fanpages, Those are great ideas.  I renamed her old profile and deleted her out of the registry, then had her log in and it created a new one.

I will put some logging on, but I am still very much wondering how this is even changeable.  If it can be changed at all then I should be able to change it back.
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 35

Expert Comment

by:[ fanpages ]
Comment Utility
Thanks.

Oh yes, I agree.  If changed one way, it should be logical to assume such a change can be reversed.

My initial thought was either font face, or font size, differences between the "Standard Font" (or "Default font" [as it is referred to now]) settings for your colleagues.

However, I have seen issues in the past with Windows screen drivers (due to differences in physical VDU hardware, or different versions of the screen drivers installed on different machines).

Also, the use of ActiveX controls on worksheets can sometimes cause issues that increase font &/or column sizes, if the controls are not the currently supported versions (or differ between machines that use the same workbooks).
0
 
LVL 4

Author Comment

by:Kent Fichtner
Comment Utility
There doesn't seem to be any thing out there that can fix this.  I am going to keep looking.
0
 
LVL 7

Expert Comment

by:Robby Swartenbroekx
Comment Utility
I have had an issue with excel cell heights.
Eventually, the problem seemed the magnifier tool in Windows 7.
If you go to control panel, display (with clasic look), you can change the size of text and other items on your screen (The control panel screen I'm talking about).

I had to change it back on all computers to 100% to resolve my issue.
0
 
LVL 4

Accepted Solution

by:
Kent Fichtner earned 0 total points
Comment Utility
I didn't find a solution on this, but it turns out she was just covering for someone else for the day and doesn't need to do the upload.  I guess the world may never know what is going on.
0
 
LVL 35

Expert Comment

by:[ fanpages ]
Comment Utility
...I guess the world may never know what is going on.

Yes, very few with be any the wiser if you request this question be deleted, without confirming what you tried prior to your response in the comment with ID: 39265756.
0
 
LVL 4

Author Closing Comment

by:Kent Fichtner
Comment Utility
There is no solution
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now