Rory again it's you! Thank you so much for your interest.
I don't understand your question, as I don't know about data models. As far as I know it is a regular pivot. I achieve it by inserting a new pivot table, specifying where it will stand and then adding the various rows and columns I need. The data is a query from a well known accounting package. When the query is updated I update the pivot table by the following code.
NameStr is "PivotTable" & TableNo
I have had similar problems in the past after times when I have added or removed rows or cols from the datarange you are asked to provide when constructing a pivot table.
The pivot does not recognize the change and usually has to be replaced by a new one. This solution did not work though this time.
I will copy the whole of the data range into a new workbook and create a pivottable there. I f the problem shows up when I edit after making the pivot I will attach it and risk the wrath of the forum powers.
John
Bookmarks