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
|