Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
External link to Named Range
I have a workbook that contains several worksheets. The worksheets are broken
down into named ranges representing a week of the month. I have a webpage that is linking to these named ranges with basic HTML. What has happened now that we are using Excel 2007 is that no matter what link you select on the webpage, the workbook opens to the last place that it was saved. This has even affected workbooks that were originally created in Excel 2003. So this link <a href="stats/fiscal_05_stats.xls#stats100404"10/04/04</a Doesn't direct you to the named range stats100404, it takes you to the last cell that was active when the workbook was saved. Does anyone have an idea as to what might be causing this behavior? I have tried modifying the link to a specific cell range i.e. <a href="stats/fiscal_05_stats.xls#'sheet1'!B3"10/04/04</a and that has had no impact on the issue at all. Hoping that someone out there might have an idea or two! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
#REF on Links to Named Range in External Workbook | Excel Discussion (Misc queries) | |||
external named range problem | Excel Discussion (Misc queries) | |||
Named range links to external workbook, help! | Charts and Charting in Excel |