Forum Discussion
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 ...
Have attempted to use the lock cell function in Format picture but this still doesn't seem to work
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