View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default Print Named Cells highlights web link to Excel range

I just went to:

INSERT/NAMES/PASTE

Excel then pasted all the names in spreadsheet I am reviewing. As usual it
also pastes names that used to exist and have been deleted. One of the old
names called "Query" had the following formula in it:

='https://blahblahblah.com/123/ABC/Documents/[spreadsheet1.xls]Detail'!$A$1:$F$951

What does this imply? Does this mean that this was at one time a Web Query?
It seems to have an excel address in it. Or is this an example of XML?

Thanks

EM