M
mc
Excel is limited to 65,536 rows. What is the work around
to make this limit higher?
to make this limit higher?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
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)
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
3
39N95W
mc said:Excel is limited to 65,536 rows. What is the work around
to make this limit higher?
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-
J
Jason Morin
The workaround is to use more than 1 worksheet or switch
to another spreadsheet package.
HTH
Jason
Atlanta, GA
to another spreadsheet package.
HTH
Jason
Atlanta, GA
R
Ron de Bruin
Hi mc
No work around
But you can use more sheets maybe.
Or use a Database like Access
No work around
But you can use more sheets maybe.
Or use a Database like Access
J
Jamie Collins
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.
LOL! What a great mental model: use Excel >> try to use MS Access >>
edge of known universe is reached.
Jamie.
--
T
Tony Duarte
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: 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!
J
Jamie Collins
[email protected] (Tony Duarte) wrote ...
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'?
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.
--
Read a plea for help, read somebody
else's answer...make fun of him...
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...
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.
--