Forum Discussion
Pivot Table
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!!
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
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.
- Thanks a lot Hans, unfortunately, despite having followed the instructions, the data in the date column is still in the same wrong format. Thanks anyway for your support! and nothing happens when trying to change the format of this column:
2022-10-03 UBS L023 6236 0 1191533
2022-10-03 UBS L023 6236 0 1191624
2022-10-03 UBS L023 6236 0 1193382
2022-10-03 UBS L023 6236 0 1197963
2022-10-03 UBS L023 6236 0 1198878
2022-10-03 UBS L023 6236 0 1198878
2022-10-03 UBS L023 6236 0 1199318
2022-10-03 UBS L023 6236 0 1199556
Thanks again!
Best regards,
BettynaCould 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?
