Solved

Excel 2010 Web Pages and Chrome Browser

Posted on 2012-03-10
10
1,183 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
  • 4
  • 4
10 Comments
 
LVL 50

Assisted Solution

by:teylyn
teylyn 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 39

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
 
LVL 50

Expert Comment

by:teylyn
ID: 37712470
How does the page look when viewed with Internet Explorer?
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

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

Accepted Solution

by:
teylyn 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

Expert Comment

by:teylyn
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
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 use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

708 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now