Forum Discussion
Edge and IE give different answers
The image below shows the same spreadsheet, opened in two different browsers, the left window using Edge, the right IE. Although the first few lines look almost identical, as you scroll down values disappear. As you can see, the browsers give different results - a lot of data is simply missing in the Edge view. Any thoughts?
Hello,
are your screenshots showing Excel Online? Or how are you viewing Excel in Edge and IE?
It seems that in the left hand screenshot, data breaks into two rows. Could it be that the cells with the "missing" numbers are simply not high enough to show the number?
What do you see when you edit the spreadsheet? What is the cell value in the formula bar?
This is a file from on premise SharePoint, so not Excel on line.
I think you may have spotted what is going on. Increasing the row height does indeed reveal the numbers. But it is not as simple as increasing the column width. Looking closer, it does not matter how wide the cell is, the currency sign (£) is always on a separate line to the value, when displayed in Edge.
Cell format is set to accounting. I suspect changing to currency would sort it.
Well, you tagged with Excel Online in your question.
If you are not using Excel online, what are you using to display Excel workbooks in a browser?
Edge has a lot of problems displaying content that other browsers display just fine. If you are using on premise SharPoint with Excel Web services or something like that, it may very well be that Edge is not up to the task. For many things related to SharePoint on premise, Internet Explorer is not only the best, but the only browser that does all the things that SharePoint needs doing, for example Office integration with ActiveX controls. IE has a number of built-in features that recognize SharePoint interfaces.
Chrome does not. And it seems that Edge does not, either.
So, don't use Edge with SharePont on premise. Edge was created as a fancy, fast, web browser, but it does not do well with legacy web content served by SharePoint Server environments.
