Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default Print Named Cells highlights web link to Excel range

This was an Excel spreadsheet that was stored on a web server. a web site
address is merely a way of giving a name to the server that houses
informaiton. Think of the http://....com part as your C: drive being
available on a network. Then, you have the subdirectories after the /'s down
to the file name.

"ExcelMonkey" wrote:

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

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
Excel2000:How to link Print Area with a named range Arvi Laanemets Excel Discussion (Misc queries) 5 April 8th 08 02:35 PM
Excel2000:How to link Print Area with a named range Arvi Laanemets Excel Worksheet Functions 5 April 8th 08 02:35 PM
Link to a named range in another worksheet that is sorted frequent ShortBlonde Excel Worksheet Functions 2 March 18th 08 04:32 PM
External link to Named Range Fleone Excel Discussion (Misc queries) 0 December 18th 07 09:52 PM
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


All times are GMT +1. The time now is 10:59 AM.

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"