View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GPO GPO is offline
external usenet poster
 
Posts: 12
Default 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