Nick Denny
asked on
Cannot see data unless zoom is less than 100% plus column width problems
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
None of those issues viewing your file on my machine.
ASKER
I have saved the file at 99.9%
Have you both tried setting back to 100%
Thanks
Have you both tried setting back to 100%
Thanks
Yes I have at 75%, 99% 100% and 150%
All look good.
Thanks
JC
All look good.
Thanks
JC
Same here.
ASKER
@JC - I think you've called it.
If I change the font, all the issues go away.
Very strange.
And good call.
If I change the font, all the issues go away.
Very strange.
And good call.
ASKER
However, if I copy and paste as values - the problem goes away......
Must be in the formatting ...????