Exporting to Web-page problem

GiMan

New Member
Joined
Jan 29, 2020
Messages
2
Office Version
  1. 2013
Platform
  1. Windows
Hello to everyone, after weeks of unsuccessful attempts I kindly ask for an opinion.

It concerns exporting the print area of XXX.xls Sheet1 to web page (.htm); the xls sheet contains data and images (jpg, gif …. imported from the outside).

Well, with an old Excel 2003 (on Windows 10) there are no problems: the XXX.htm file and its XXX_file folder are correctly generated, limited to the print area as required, fully functional.

With Excel 2013 that’s not working. The file XXX.htm is created with the relative folder XXX_file containing the images, but when I open the .htm in the browser (Chrome, FireFox) the images are not there (everything else yes). Looking at the contents of the htm file, I note that there are no <img> tags as in the other one (2003), instead thousands and thousands of lines - similarly to what happens when the export is done to a “unique file web page” (.mht): but the extension of the generated file is correct (.htm), and the external folder “_file” is OK! (all images in there).

Excel 2013 is updated (it runs on Windows 7).

Tried with all possible combinations (without print area, all Sheets, etc.), but nothing changes. The .htm file can reach 70000 lines.

Tried to export to .mht format (unique web page): it works (but there are problems with this type of file with non-IE browsers).

Many many thanks for some suggestions.
 

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
4,096
See if this video is of any use. Since I do not have a microphone it is soundless.

video
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,123,231
Messages
5,600,427
Members
414,384
Latest member
joehalks

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top