Pivot misses a row

I have a data table (160 Rows * 28 Columns) which I want to condense by using a pivot table.
All works well at first until I had to edit one item of the data set in the column containing the items used by the pivot to sum the data. When I refreshed the pivot, the edited item and the data it referencing was missing.
The attached workbook shows a selection from the data table including the edited row (tc in ColK). But here the pivot table has not missed out tc.
Seeing this I went back to the full data set and ran another identical pivot to the original and again tc was missing.
What is happening here? I have presumed it is something to do with editing tc but does that mean that I will have to set up a new data table, and pivot that anew?
John

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.

Please Login or Register  to view this content.

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

I have just copied the data, made a pivottable then amended one of the code letters and refreshed the pivottable. The amended code letter was picked up.
Don't spend any more time on this. I will completely redo the data and the pivot without the edit. If I am still in trouble I'll come back again.
John

A new pivottable allowed me to continue. Strangely it also allowed editing of the "code" column of the data table. I've put it down to experience.
John