Solved

Excel 2010 Web Pages and Chrome Browser

Posted on 2012-03-10
10
1,251 Views
Last Modified: 2012-03-17
Saving excel worksheet with several graphs to a *.htm file.   Files to be viewed with Chrome Browser.  

With the Excel 2010 Web Options set to allow VML, Chrome does not load the graph images.  There is one image (.png) file for each graph in the *_files folder associated with the *.htm file.

If the VML option is unchecked, Excel creates 2 copies of each image in the *_files folder associated with the *.htm file.  This works with Chrome, but the file is bloated because of the duplicate images.  See attached examples.

If the same page is created using Excel 2003, the duplicate image files are not created and Chrome works fine.

Is there a way to configure Excel 2010 to avoid the duplicate images and be compatible with Chrome? i.e. make it work like Excel 2003?
0
Comment
Question by:BW999
[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
  • 4
  • 4
10 Comments
 
LVL 50

Assisted Solution

by:Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 334 total points
ID: 37705793
Hello,

the html generated by Excel is not always standards compliant, so the content will render differently in different browsers. You will probably get the best rendering in Microsoft's own browser, Internet Explorer, but any other (standard compliant) browser will be very much hit and miss. There is not much you can do at your end, since you cannot change the way that Excel 2010 generates the html.

cheers, teylyn
0
 
LVL 40

Assisted Solution

by:als315
als315 earned 166 total points
ID: 37706154
You can try to use add-in for chrome: IE Tab. It can show pages in IE from chrome:
https://chrome.google.com/webstore/detail/hehijbfgiekmjfkfjpbkbammjbdenadd
0
 

Author Comment

by:BW999
ID: 37712404
Thanks for the suggestions.   Hit or miss sounds right.   I tried the Chrome Add-ins without success.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 50
ID: 37712470
How does the page look when viewed with Internet Explorer?
0
 

Author Comment

by:BW999
ID: 37725680
Internet Explore works fine.
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 334 total points
ID: 37726500
I thought it might. There's really not much you can do, because as an end user you cannot change how Excel generates the html. It's optimized for IE, so if you use another browser, you're out of luck.

cheers, teylyn
0
 

Author Closing Comment

by:BW999
ID: 37726853
Thanks.
0
 
LVL 50
ID: 37727885
BWW999, can you please explain the B grade? The answers are valid and correct and deserve an A. I understand that you don't like the fact that the pages don't render correctly in Chrome, but sometimes "you can't do that" is the correct answer.
0
 

Author Comment

by:BW999
ID: 37729100
I apologize.  The grade should have been "A" based upon your criteria.   I asked the moderator to change it or tell me how to do that.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

622 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