| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to extend data to next sheet automatically during sql query
When returning data from excel query builder, if the data exceed 65536 rows
then an error pops up. Can we extend the remaining data to next sheet automatically. Can u plz suggest. |
|
#2
|
|||
|
|||
|
As a work around, you might want to create a pivot table that imports
external data. That way your not stuck with that same limitation. "Asha" wrote: When returning data from excel query builder, if the data exceed 65536 rows then an error pops up. Can we extend the remaining data to next sheet automatically. Can u plz suggest. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
| Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
| Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
| Merger Two Data Sheet | Excel Discussion (Misc queries) | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Linear Mode
