Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 50
Default Named Range Links not working

I am unable to have a link to a named range in Excel 2007 work from any
external location.
When selecting a link to a named range from Internet Explorer, or by UNC
path in our Wiki, the Excel 2007 workbook opens to the last cell selected
when the file was saved and closed.
I have been scouring the web for this issue and have not found any
information on it.
The same workbook in Excel 2003 works fine, all links from outside will
connect to the appropriate named range.
I have "heard" that this is what some might call a "known issue". Is this
so, or am I clearly not doing something correctly.
Try this in Excel 2007:
Open a workbook, pick a sheet.
On that sheet, select a cell and give it a name using the Name Box.
Save the workbook as an *.xlsx file, but from A DIFFERENT CELL on a
DIFFERENT WORKSHEET.
Now, generate a link to the named range using the browser of your choice.
Watch where the workbook opens from.

Example:
Workbook.xlsx has a named range €śnamedrange€ť on sheet 2, cell B4. Save
workbook.xlsx with cell A1 on sheet 1 selected then try to open it from a
browser.
http://servername/workbook.xlsx#namerange
This will open the workbook to€¦€¦Cell A1 on sheet 1, not your named range!
I have tried this declaring sheet names instead of named ranges in my path
and there is no difference.

Any ideas?

Thanks!

  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default Named Range Links not working

I just tested this using on Excel 2007 SP1 and it worked correctly -
the Hyperlink took me to the named range.

Is your Excel 2007 up to date?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
My Dynamic Named Range isn't working Carrie_Loos via OfficeKB.com Excel Worksheet Functions 11 February 22nd 08 11:09 PM
Formula not working when letter A is used in a named range jimar Excel Discussion (Misc queries) 7 July 6th 06 11:43 AM
inserting a named range into new cells based on a named cell Peter S. Excel Discussion (Misc queries) 1 June 4th 06 03:53 AM
#REF on Links to Named Range in External Workbook [email protected] Excel Discussion (Misc queries) 1 April 6th 06 03:02 PM
Named range links to external workbook, help! WitchMaster Charts and Charting in Excel 2 October 11th 05 12:07 PM


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"