Exporting to Web-page problem

[GiMan]

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]

Welcome to the Board



I tested this with Excel 2013, saving only one sheet with no print area defined. After publishing it, I opened it with CCleaner browser and the image was there, see below picture.

 

[GiMan]

Thanks for your answer. I tested the files on Windows 10, and they work. So, there is something in Windows 7... i will upgrade it to 10

 

[DaronX]

I have same problem. I drew a shape, saved it as a html and I can't see anything

 

[Worf]

What Windows version are you using? I suppose it is Windows 10.

 

[DaronX]

Windows 10, Office 19

 

[Worf]

See if you can visualize the shape on the HTM file I created:

zipped

 

[DaronX]

I see the sun. Send me excel file. I will try to add shape.

 

[Worf]

Here is my test workbook. Note the protocol I used:

Save as / HTML / save sheet / publish / open in browser / publish.

source file

 

[DaronX]

I opened your excel file / save as / web page / publish / open in browser / publish ......... and it opened blank page