Solution to the error "The number of columns in the data does not match the number of columns in the range"

Did you try to modify a query and got the error "The number of columns in the data does not match the number of columns in the range"?

Don´t worry, this happens because you tried to modify a query with the "combine new with old results" option selected.

Follow these steps to fix it:

1. Click on Modify to modify the query

2.  Uncheck the option "combine new with old results"

3.  Modify your query by selecting the new desired parameters.

4.  Click on confirm changes. This will generate the table with the new modifications.

5.  Modify again, and select "combine new with old results".

6.  Confirm changes and you will have your modified query without the error.

 

As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!