Error: "The query returned more data than will fit on a worksheet"

error-handling popup excel-2010 excel-external-data
Toli picture Toli · Aug 25, 2016 · Viewed 8.9k times · Source

When I refresh my workbook, the following message pop-ups : "The query returned more data than will fit on a worksheet"? I have around 30 Sheets which have connections to external queries. How to check from which sheet this error is coming and how to solve it?

THanks!

enter image description here

Answer

user7960156 picture user7960156 · May 4, 2017

In the External Data Properties for each data connection where it says: "If the number of rows in the data range changes upon refresh" try the setting "Insert entire rows for new data, clear unused cells."

Related questions

Android setError("error") not working in Textview

We can set error in Edittext successfully but failed to set in textview. is there any problem?? i tried ((TextView) findViewById(R.id.df)).requestFocus(); ((TextView) findViewById(R.id.df)).setSelected(true); ((TextView) findViewById(R.id.df)).setError("akjshbd"); but …

Read More
How do I get PHP errors to display?

I have checked my PHP ini file (php.ini) and display_errors is set and also error reporting is E_ALL. I have restarted my Apache webserver. I have even put these lines at the top of my script, and …

Read More
400 BAD request HTTP error code meaning?

I have a JSON request which I'm posting to a HTTP URL. Should this be treated as 400 where requestedResource field exists but "Roman" is an invalid value for this field? [{requestedResource:"Roman"}] Should this be treated as 400 where "blah" field …

Read More