Solved

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

Posted on 2014-02-03
7
291 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
  • 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

770 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