Do you know how to make Excel bookmark work when it's saved as a WebPage?
I have a multi-sheet Excel workbook. The first page contains
hyperlinks to cells in the other worksheets. I use 'Define Name' to name the target cells in the other sheets, and have the hyperlink point to it. This works fine when I'm in the Excel application. However, when I save it as a web page (htm) the hyperlinks are referring to the names as if they were bookmarks (e.g. http://page.htm#bookmark, but the target cells are using the actual cell range as the book (e.g. #RANGE!A286). As a result, the link is broken. Does anyone know how to do this so that it will work? Additional Info: if the target cell is on the same worksheet then both the hyperlink and the actual bookmark use #RANGE! as the reference and the link does work. But when the hyperlink and the target cell are in different worksheet this breaks. |
All times are GMT +1. The time now is 09:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com