I get this error whenever I try to calculate pivot items in excel. There is literally only date in columns and cost in values. So it is simplified. I do use a macro but the macro only refreshes the entire workbook. It doesn't do anything with the pivot. On the other hand, the data is gotten from another excel sheet saved to my one drive. I can make calulated fields just not items.
Can someone please help?