Search results for query: *

Thanks for the thoughts. Unfortunately Query seems to be having problems with my named ranges. I had actually tried using the "Get External Data-Import Data" command previously, but doing that only imports the values without the names of the ranges. Using the Query wizard gave me "Syntax error...

Hi Skip, Thanks for your response. The ranges are multiple cell ranges, and the purpose of linking them is that I want to be able to make changes in one central file that then update to several other files which have drop-down menus that use these ranges. I'm not familiar with MS Query. Any...

I'm trying to create a link that links several named ranges from one workbook to another. I am able to link the values, but when I create the link using paste special-paste link, it only pastes the values in the range and not the range name with it (which I need in order to use the named range...