I have a workbook I've been using for a couple of years and refreshing the 
data queries pretty much daily.  All of a sudden the "Refresh" item on the 
right-click menu is grayed out.  I similarly can't get the data to 
refresh -- it pulls from a CSV file I download -- via other means.  I tried 
deleting the query and recreating it.  Same thing.  This has me baffled. 
Any ideas?

Thanks,
Sarah 

Is the worksheet that contains the query protected?  That can have the effect 
of "graying out" a lot of functions you can normally access.

HTH,

Eric

"Sarah H." wrote:

> I have a workbook I've been using for a couple of years and refreshing the 
> data queries pretty much daily.  All of a sudden the "Refresh" item on the 
> right-click menu is grayed out.  I similarly can't get the data to 
> refresh -- it pulls from a CSV file I download -- via other means.  I tried 
> deleting the query and recreating it.  Same thing.  This has me baffled. 
> Any ideas?
> 
> Thanks,
> Sarah 
> 
> .
> 

Eric,

Nope, the sheet's not protected.  I've gone through about every usual and 
unusual thing I can think of and done a web search, as well.

I even deleted the query from the sheet and recreated it.  Same thing.

I finally added in a new worksheet and re-made the query there from scratch. 
That worked.  So I copied over my formatting and moved the bad-acting sheet 
to a new workbook for further study as to the problem.

For the record, the workbook was imported from Excel 2002 and has been 
re-coded for Excel 2007, and I very recently deleted a bunch of hidden pages 
that were causing annoying pop-up errors of the type: "A formula in this 
worksheet contains one or more invalid references."

I also seem to have some stub chart objects in the workbook that won't let 
themselves be deleted.  I don't  know what that's about.  I see them when I 
look at the workbook's VBA Project pane.  While there are no more pop-up 
errors, all the pages that had queries on them before I deleted extraneous 
old hidden pages now have the same grayed-out wording for query "Refresh," 
though the data-range properties are still there and editable.

I used every one of these sheets -- and there are 27 of them, if I've 
counted correctly -- as recently as last Saturday.  But it was after that 
that I deleted the deprecated hidden sheets.  I strongly suspect that as the 
cause of this inexplicable circumstance.

-- 
Regards,
Sarah

"EricG" <EricG@discussions.microsoft.com> wrote in message 
news:705ED44C-4AE3-44B9-B538-A1F284AEA45D@microsoft.com...
> Is the worksheet that contains the query protected?  That can have the 
> effect
> of "graying out" a lot of functions you can normally access.
>
> HTH,
>
> Eric
>
> "Sarah H." wrote:
>
>> I have a workbook I've been using for a couple of years and refreshing 
>> the
>> data queries pretty much daily.  All of a sudden the "Refresh" item on 
>> the
>> right-click menu is grayed out.  I similarly can't get the data to
>> refresh -- it pulls from a CSV file I download -- via other means.  I 
>> tried
>> deleting the query and recreating it.  Same thing.  This has me baffled.
>> Any ideas?
>>
>> Thanks,
>> Sarah
>>
>> .
>>