Solved

Cannot see data unless zoom is less than 100% plus column width problems

Posted on 2014-02-03
7
303 Views
Last Modified: 2014-02-03
Hi Experts

I have just installed my Excel 2007 onto Windows 8.1 and am having some issues .
I have attached a pricelist workbook (single sheet).
On my machine I can only view info in the cells if the zoom is set to less than 100% (e.g. 99.9)
If I go back to 100% the data becomes invisible.
Also, if I do an autofit column width (select all cells and double click between the letters on the column letters) the columns are jumping to max width (255 pixels).
I have deleted all blank rows and all blank columns and then saved- same problem.
I have also done a "=len()" on each to ensure there is no extra characters.

I suppose it may just be a local issue on my machine but if I could get some feedback that would be great.

Many thanks

Nick
pricelist-issue.xlsx
0
Comment
Question by:Nick Denny
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 13

Author Comment

by:Nick Denny
ID: 39829383
Additional note on this - if I copy and paste onto a new workbook, I have the same problem.
However, if I copy and paste as values - the problem goes away......
Must be in the formatting ...????
0
 
LVL 14

Accepted Solution

by:
John-Charles-Herzberg earned 500 total points
ID: 39829387
It might be the font your are using.  It looks good on a MAC.  What font are you using?

Thanks
JC
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39829391
None of those issues viewing your file on my machine.
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
LVL 13

Author Comment

by:Nick Denny
ID: 39829415
I have saved the file at 99.9%
Have you both tried setting back to 100%
Thanks
0
 
LVL 14

Expert Comment

by:John-Charles-Herzberg
ID: 39829423
Yes I have at 75%, 99% 100% and 150%

All look good.

Thanks
JC
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39829427
Same here.
0
 
LVL 13

Author Comment

by:Nick Denny
ID: 39829428
@JC - I think you've called it.
If I change the font, all the issues go away.
Very strange.
And good call.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

688 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