Data Query grayed out

  • Thread starter Thread starter Sarah H.
  • Start date Start date
S

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
 
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
 
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.
 
Back
Top