Excel Spreadsheet View Issue XP and 2003 versions.

iains

New Member
Joined
Jul 21, 2009
Messages
3
On a series of spreadsheets I can see from A1 to N29 on 100% view (XP) (14 Columns), however one of my users can see from A1 to EE29 (so it is very condensed) (109 columns), also on 100% view (2003). The print preview is also mis-aligned.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
This is only an issue on about 20 spreadsheets, of similar layout, others are fine.
<o:p></o:p>
If the user views the problem series on other machines then they are fine.
<o:p></o:p>
There is nothing obvious in preferences, and the other workbooks are ok.

My screen is 15” at 1280 x 960; the user has a 17” at 1290 x 1024.
<o:p></o:p>
I appreciate that you would see more on a larger screen, but not to the point that the screen can not be worked with.
<o:p></o:p>
The user with the issue is seeing 109 columns, whereas I see 14. I would not expect that much difference to the working screen.

I’ve changed the monitor twice, once to an identical 17” monitor, and once to another 17” model.
<o:p></o:p>

Each time the spreadsheet view is compressed.
<o:p></o:p>

The spreadsheets in question were working fine up until 30 June, when the used went on holiday, an on their return on 08 July the view was causing problems.
<o:p></o:p>

No other issues with this user account or system.

Kind regards
<o:p></o:p>
Iain Stedman
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Forum statistics

Threads
1,215,731
Messages
6,126,537
Members
449,316
Latest member
sravya

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top