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.
- Thank you very much, that fixed it!
Not that it matters, but I have to trim the information as the data I'm importing has different analytics included in columns that move to a new column every week and mess up my summation equations. It's easier to hardcode a filter than to update the PQ references each week. I'm sure there's a better way to do this, but with my level of understanding, this is the easiest way for me to get what I need done.
