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 be solved
Thank you
Asvatz
2 Replies
- asvatzCopper Contributor
Have attempted to use the lock cell function in Format picture but this still doesn't seem to work
- asvatzCopper 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