This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a table that gets the brazilian inflation from a query, with the new year, it should add another row.
I want it to add an entire row, not just cells under it.
In the External Data Properties dialog box, select that option, but once I click ok and the box closes, it doesn't register my choice and it comes back to the default one that only adds cells below the table.
For some reason I can't upload the screenshots
Excel - External Data Properties 1.png
Excel - External Data Properties 2.png
If I try to refresh the data the way it is, it breaks other things that don't have the same number of collums.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
The first two options you mentioned I already tried widout success, I'll try the third one.
Thank you for the information.
I will send it to relevant team. Hope Microsoft will make improvement on it in the near future.
Here is same ways to send feedback to Micrsoft directly.
1, Customer service phone numbers - Microsoft Support
2, Raise a support ticket. Please contact your admin/IT department create a support ticket via Microsoft 365 Admin Center> Support> New service request. Get support - Microsoft 365 admin | Microsoft LearnAbout how to find the admin in your organization, you can refer to How do I find my Office 365 admin
From your screenshot, is it possible to move that query table to the end of that sheet to make sure all other table will not be overlapped?
Or you may try adding some blank columns in your query table to make your query table has higher rows count than other tables below that query table.
I have muitiple queries of various economic indexes (things like the value of the dolar/reais, dolar/euros and things like that), usualy followed by something to make the use of the data more prectical for the rest of the file.
Moving all the queries to the bottom in the order from wider to thinner would make my file messy and less practical for working.
And I also have things to the side of the table of the query.
Is there a solution to allow me to chose to add an entire row when the table gets one mor column?
I would prefer not to use work-arrounds.
If you have a way to contact tecnical suport directly from microsoft for this kind of problem, I would also be happy.
From your screenshot, is it possible to move that query table to the end of that sheet to make sure all other table will not be overlapped?
Or you may try adding some blank columns in your query table to make your query table has higher rows count than other tables below that query table.