Forum Discussion
Links to Query Table Sheet not Updating
TryggM Can't really imagine why you would do the 'trimming' (whatever that is) outside PQ, but what you describe is default behavior of PQ generated tables. They insert rows and columns when they expand so that they don't accidentally overwrite existing data. But you can change that under Properties on the Data ribbon in the Queries & Connections group. Select the bottom radio button as shown in the picture below.
TryggM Can't really imagine why you would do the 'trimming' (whatever that is) outside PQ, but what you describe is default behavior of PQ generated tables. They insert rows and columns when they expand so that they don't accidentally overwrite existing data. But you can change that under Properties on the Data ribbon in the Queries & Connections group. Select the bottom radio button as shown in the picture below.