Forum Discussion
Power Query table range
I am using a power query at work that someone created before me. I paste the data I want to analyze into a tab within the worksheet and select the refresh button. The data I pasted today has 552 rows...
Usually Power Query takes as source structured table or named range. If the latest check in Name Manager how the name is defined and correct if necessary.
- Yes, thank you, I am aware of this table and have tried to resize it. I must be missing something because when I try to change the range in the resize table box it does not correct my issue.
That's straightforward operation
and you always may check in Name Manager what is the actual size.
Thank you, yes I am aware of that as well. I have tried to edit this before it said $A$1:AAC$490 so I tried $A$1:AAC$700 and selected OK. It resorts back to the $A$1:AAC$490 every time.
