Forum Discussion

asvatz's avatar
asvatz
Copper Contributor
Feb 10, 2020

Saving Excel worksheet as a webpage

Hi everyone

Am attempting to save an Excel worksheet as a webpage.

There are numerous photos and text boxes.

These photos & text boxes move out of position when saving the worksheet

How can this be solved

Thank you

Asvatz

2 Replies

  • asvatz's avatar
    asvatz
    Copper Contributor

    Have attempted to use the lock cell function in Format picture but this still doesn't seem to work

    • asvatz's avatar
      asvatz
      Copper Contributor

      Solved

      It seems that locking some of the images |& text boxes is not sufficient to solve the problem but ensuring that all images and text boxes are locked does seem to be the solution. I have over 700 of these items on a single worksheet but was able to perform this action by executing select all for images & text boxes and then size & formatting them all. This allowed me to successfully convert the excel file to a webpage. unfortunately all the links are underlined, another problem.

       

      I suspect i used the wrong file format to create the input data for my website. Any advice would be greatly appreciated

         

Resources