Solved

Excel 2010 - Pixcel Size Differences

Posted on 2013-06-05
12
139 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 ]
ID: 39223417
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
ID: 39223441
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 ]
ID: 39223452
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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 4

Author Comment

by:Kent Fichtner
ID: 39223479
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 ]
ID: 39223512
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
ID: 39223698
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
 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 39223796
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
ID: 39265756
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
ID: 39341247
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
ID: 39439107
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 ]
ID: 39439230
...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
ID: 39454694
There is no solution
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show you how to use shortcut menus in the Access run-time environment.
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

778 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