Excel Publish creates html file but displays html code not text

Question

I published a workbook, which creates the .html file and folder containing all the support files. I open the html file in a browser and it displays the html code, not the workbook. This worked before, now I can't get it to open the workbook properly. 

Answer 1

Hi JoeGuestSr,

Based on your description, after publishing the Excel workbook to html file, it won't open the workbook from the browser.

You can try to switch to other browsers to open the html file. And may I confirm that whether the problem happen on all the Excel files?

Additionally, I found a thread which has the similar problem with you: Converting HTML to Excel?. You can try the VBA code in this thread to check whether it could help you.

Additionally, please provide a screenshot of your Office Product Information(open Excel>File>Account>capture a screenshot of the Product Information column).

Best regards,

Jazlyn

Answer 2

Jazlyn, it happens with all browsers. Your question about any other Excel files got me thinking... this only happens for html files saved on OneDrive. If I open the local copy of the same OneDrive file it opens correctly. This appears to be an issue with OneDrive both Business and personal. I am closing this post and moving it to OneDrive. 

Thanks.

Answer 3

Sorry, missed the request for my account info. Here's a screenshot: 

Also, as I stated in my initial post, THIS WORKED LAST OCTOBER, no need for VBA code, just a simple iframe to insert into my webpage. What changed with OneDrive since then?

Answer 4

Hi JoeGuestSr,

Thank you for the reply.

You mentioned that the problem happened on the HTML file stored in OneDrive, I tested it on my side(save HTML file on the desktop and upload to OneDrive), there was no problem.

If your steps are not same as mine, could you please provide the detailed steps for me? Additionally, could you please provide a sample file for me via private message? So that we could test it on our side.

Best regards,

Jazlyn

Answer 5

Jazlyn, I am saving / publishing to my OneDrive folder on my computer, then opening from OneDrive in a browser. I also followed your procedure of saving / publishing in a local folder and copying to OneDrive, same error. Attached is what I see when I open from OneDrive, if I open the same file from my C: drive it opens correctly.

Notice in the top right, it shows “3 of 7”. If I move to 5 of 7, it is the xlsx file, and it opens in the browser in Excel.

I downloaded the file, and it opens correctly, as I said before, the local copy of the file opens correctly from my OneDrive folder on  my C: drive. Only the OneDrive copy will not open properly.

I have an older HTML file on my business OneDrive that opens correctly, but anything recently created opens incorrectly.