Hello. I wanted to alter the Money Market Stock Quotes query that comes with Mac Excel 2011. Instead of retrieving the entire page, I only wanted to retrieve the Last price, so I typed in "Last" next to Selection=. The original query text is below. But when I go to run the query, it is now greyed out. Even after putting back "EntirePage" and saving, the query is still greyed out. I have tried quitting Excel and reopening it, but no luck. I read that the 3 queries that come with Mac Excel cannot be modified. At this point I just want to put back the original query.

****If you are able to make a copy of that file and send it to me here, please do. It's in the Application-Microsoft Office-Office-Queries folder. I would greatly appreciate it.

The actual query text contained in the text file is below if you want to take a look. Thanks.

WEB
1
http://moneycentral.msn.com/investor...es.asp?SYMBOL=["QUOTE","Enter stock, fund or other MSN MoneyCentral Investor symbols separated by commas."]

Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False