Refresh Data is grayed out, even when I change data. Please help.

Is this in a pivot table? Is the sheet protected, or is the workbook shared?

rob wrote:
Refresh Data is grayed out, even when I change data. Please help.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

I reviewed your website and would appreciate your response on a problem that
just creeped up in my pivot table worsheet. I select refresh data and the
table goes blank. I have refreshed this table a million times and no
problem, just happened today. Is this a virus or a worksheet malfunction -
there are about 5300 rows in the data worksheet.

Please advise.

Best Regards,
EMoorhead
--



"Debra Dalgleish" wrote:

Is this in a pivot table? Is the sheet protected, or is the workbook shared?

rob wrote:
Refresh Data is grayed out, even when I change data. Please help.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Right-click on the pivot table and choose PivotTable Wizard.
Click the Back button, and check that the correct range is selected as
the source data.

Eleanor M wrote:
I reviewed your website and would appreciate your response on a problem that
just creeped up in my pivot table worsheet. I select refresh data and the
table goes blank. I have refreshed this table a million times and no
problem, just happened today. Is this a virus or a worksheet malfunction -
there are about 5300 rows in the data worksheet.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html