I have excel spreadsheet with lots of tabs and 1 tab with workbook connections linking to other spreadsheet. It was working fine and after I have done some field update, these message error appears :-
The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled colums. If you are changing the name of the PivotTable field, you must type a new name for the field.
This operation is not allowed. The operation is attempting to shift cells in a table on your worksheet.
Cannot complete oreation: A table cannot overlap with a PivotTable report, query results, a table, merged cells, or an XML mapping.
Bookmarks