https://bugs.documentfoundation.org/show_bug.cgi?id=162417
--- Comment #8 from ady <adylo811...@gmail.com> --- (In reply to Robert Lacroix from comment #5) > Nope. Tldr; The request is to prevent growth of a pivot table by adding a > "locked" attribute to row fields, column fields, and page fields so that no > additional values become automatically selected when the pivot table is > refreshed and new data values are present in the source range. Please forgive my ignorance... If you don't want the PT to be automatically updated, perhaps you could copy the content of the PT to a simple table (not in the sense of Excel's Table, nor as a Pivot Table). I mean, once you built the structure of the PT, and the data is acquired in order to fill the PT with content, can't you just copy the result to a simple table? The result of that copy should be independent of the original data, breaking the relation to the PT. Is this a valid workaround? Is this "locked" Pivot Table request available in other spreadsheet tools? -- You are receiving this mail because: You are on the CC list for the bug.
