Print Named Cells highlights web link to Excel range

E

ExcelMonkey

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
 
S

Sean Timmons

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 highlights multiple cells when trying to select one. 5
Excel 2007 and Paste Special with HTML and data from the web 3
Excel Excel Web Query on URL: DirectGov PostCode not working 1
Uploading Excel to web site 1
Link to Access & Named Range 11
Copy web data entry page into Excel 1
Transpose not working rows to columns 3
Link Table to Excel Dynamic Named Range? 0

Top