Excel is full - Last row is used

[bullit_nl]

Hello,

I have a sheet that gets it's data from a database connection.
Now i'm at the end of the rows (nr. 1048576). How can I continue using the sheet without having to delete data?


Thank you.

 

[Tim_Excel_]

You can't, unless you continue in a new column.

You can't magically create more rows than Excel produces.

 

[jmacleary]

Hi there. Providing you are using excel 2010 or later, look into the power pivot add-in. This has a much greater limit.

 

[bullit_nl]

Ok I'll have a look at it. I don't have experience with Power Pivot add-in only a little bit with Power Query.

 

[bullit_nl]

Did some online reading but not sure if I have to use Power Pivot or Power Query. I'm using Excel 2013.
I need the info from the Database to make Pivot table sheets. Now I get all the data into my main datasheet and from there i make the Pivot Table.

Thanks

 

[bullit_nl]

I have version Microsoft Office Standard 2013 so i can't use Power Pivot add-in. I do have Power Query.

 

[Yongle]

deleted - posted in error