XFD1048576
-
Just wondering in the hot afternoon sun of West Africa what the last row and column of MS Office Excel worksheet and wasted about 10 minutes it's Column XFD, Row 1,048,576! What your mind can imagine when the weather is hot.
Shouldn't be easier to visit this page: https://support.office.com/en-nz/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3[^], while your are sitting in the air-conditioned room?
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
-
Just wondering in the hot afternoon sun of West Africa what the last row and column of MS Office Excel worksheet and wasted about 10 minutes it's Column XFD, Row 1,048,576! What your mind can imagine when the weather is hot.
Anyone who thinks he needs a million rows in Excel really needs to a shrink the data.
I wanna be a eunuchs developer! Pass me a bread knife!
-
It's 40 here today, but dropping back to the teens after today.
Elephant elephant elephant, sunshine sunshine sunshine
http://nashvilleseo.me - Local Seo Fet find in search engines
-
Anyone who thinks he needs a million rows in Excel really needs to a shrink the data.
I wanna be a eunuchs developer! Pass me a bread knife!
-
Just wondering in the hot afternoon sun of West Africa what the last row and column of MS Office Excel worksheet and wasted about 10 minutes it's Column XFD, Row 1,048,576! What your mind can imagine when the weather is hot.
Pro-Tip: Instead of spending 10 minutes scrolling, try Ctrl+Down, Ctrl+Right
Proud to have finally moved to the A-Ark. Which one are you in?
Author of the Guardians Saga (Sci-Fi/Fantasy novels) -
Pro-Tip: Instead of spending 10 minutes scrolling, try Ctrl+Down, Ctrl+Right
Proud to have finally moved to the A-Ark. Which one are you in?
Author of the Guardians Saga (Sci-Fi/Fantasy novels)Hey, that works on the Lounge thread too :-D
-
Actually we have cases where 1 million is not enough. :^)
There are only 10 types of people in the world, those who understand binary and those who don't.
Then you're using the wrong tool.
I wanna be a eunuchs developer! Pass me a bread knife!
-
Then you're using the wrong tool.
I wanna be a eunuchs developer! Pass me a bread knife!
-
Mark_Wallace wrote:
Then you're using the wrong tool.
Is there a better tool to allow users to analyze that much data?
There are only 10 types of people in the world, those who understand binary and those who don't.
-
You think Access or some other database is easier to use for a user than Excel? :omg: Nope. Wrong. Excel allows for quick formulas, easy charting, sorting, data entry, all way easier than any database program I've ever seen.
There are only 10 types of people in the world, those who understand binary and those who don't.
-
You think Access or some other database is easier to use for a user than Excel? :omg: Nope. Wrong. Excel allows for quick formulas, easy charting, sorting, data entry, all way easier than any database program I've ever seen.
There are only 10 types of people in the world, those who understand binary and those who don't.
A million records in Excel is a disaster waiting to happen. Or possibly multiple disasters that have already happened -- there's no way of verifying that it is behaving correctly.
I wanna be a eunuchs developer! Pass me a bread knife!
