Data Query grayed out

[Sarah H.]

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

 

[EricG]

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.]

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.