Nov 07 2022 02:26 AM
I would like to convert my pivot table to a normal excel table so it will be possible to make changes. Thanks a lot for your help!!
Nov 08 2022 08:20 AM
Nov 08 2022 09:21 AM
Hi Martin,
thank you very much for your intention to help.
I have already done just that, unfortunately it didn't work. the formatting stayed the same and you can't delete lines, columns or make changes.
Best regards,
Bettyna
Nov 08 2022 12:38 PM
Try pasting into a range that overlaps neither with the rows nor with the columns of the pivot table, or paste into a different sheet.
Don't forget to paste as Values or as Values and Number Formatting.
Nov 14 2022 03:59 AM
Nov 14 2022 04:09 AM
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Nov 14 2022 06:04 AM
Nov 14 2022 06:15 AM
You can attach it to a private message to me (click on my user picture)