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.
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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.

htm format.JPG
 
Upvote 0
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
 
Upvote 0
I have same problem. I drew a shape, saved it as a html and I can't see anything :(
 
Upvote 0
What Windows version are you using? I suppose it is Windows 10.
 
Upvote 0
I see the sun. Send me excel file. I will try to add shape.
 
Upvote 0
Here is my test workbook. Note the protocol I used:

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

source file
 
Upvote 0
I opened your excel file / save as / web page / publish / open in browser / publish ......... and it opened blank page :(
 
Upvote 0

Forum statistics

Threads
1,213,554
Messages
6,114,280
Members
448,562
Latest member
Flashbond

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
Back
Top