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 |
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 |
All times are GMT +1. The time now is 08:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com