ExcelBanter - Pivot Table refresh and calculated item disabled

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table refresh and calculated item disabled (https://www.excelbanter.com/excel-discussion-misc-queries/153879-pivot-table-refresh-calculated-item-disabled.html)

GPO

Pivot Table refresh and calculated item disabled

XL 2003

Hi
I have a pivot table connected to three inner joined text files via ODBC
connection string. I notice that under menu item "formulas", [Calculated
Item...] is disabled (greyed out). What can I do about this? I also notice
that Refresh Data is also disabled. Is this expected behaviour?

Regards

All times are GMT +1. The time now is 03:33 PM.