not enough rows

  • Thread starter Thread starter mc
  • Start date Start date
There is no workaround except using multiple sheets

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
mc said:
Excel is limited to 65,536 rows. What is the work around
to make this limit higher?
Click to expand...

Depends on the task. A simple but often ineffective solution is to move
data onto a second or third worksheet.

If that is not an option then I would suggest trying to use Access. After
that your options basically run out, as far as I know.

Good luck!

-gk-
 
The workaround is to use more than 1 worksheet or switch
to another spreadsheet package.

HTH
Jason
Atlanta, GA
 
Hi mc

No work around

But you can use more sheets maybe.
Or use a Database like Access
 
39N95W said:
A simple but often ineffective solution is to move
data onto a second or third worksheet.

If that is not an option then I would suggest trying to use Access. After
that your options basically run out, as far as I know.
Click to expand...

LOL! What a great mental model: use Excel >> try to use MS Access >>
edge of known universe is reached.

Jamie.

--
 
LOL! What a great mental model: use Excel >> try to use MS Access >>
edge of known universe is reached.

Jamie.

--
Click to expand...

LOL! what a great mental model: Read a plea for help, read somebody
else's answer...make fun of him...don't provide any better
solutions...

Geez... I'd stay with the Excel>Access>edge of known universe any day
of the week and twice on Sundays!
 
(e-mail address removed) (Tony Duarte) wrote ...
Read a plea for help, read somebody
else's answer...make fun of him...
Click to expand...

Yeah, that was a bit cruel. It's just that it's one of my pet hates
i.e. why not say, 'I would suggest using a database, such as MS Access
if you have it'?
don't provide any better
solutions...
Click to expand...

The popular answers had already been given: use other columns,
possibly on another worksheet; use a database; use another spreadsheet
package. But this kind of, 'Me too' post is rightly discouraged.

Jamie.

--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is the Excel 2007 rows limit for Excel 2003 macros? 0
Number of rows in Excel 2007 worksheets 3
increase total rows 2
Increase rows in worksheet beyond 65,536 row limit 2
expand number of rows from limit of 65,536? 2
Need to export to a CSV but my file has more than 65536 rows 6
Excel 2007 - million rows 2
Row Limit in Excel 4

Back
Top