online excel workstation?

[excelNewbie22]

hi,
i come to a stage where i have too many rows and columns (approx 100 mil)
and it takes me hours to fill down,
and i need to be updated it a lot,
is there's an online service strong enough to handle such tasks quickly?
and it goes without say, it need to be exactly like excel without loosing any formulas, design, and etc


i could try break it down to parts, like instead of 1mil, 10 of 100k, but it'll be tedious, and even then will take a lot of time,
or upgraded the memory to 32gb or even more if it'll make a serious difference?

 

[Fluff]

The only thing "exactly like Excel" is .... Excel.
If you have 100,000,000 cells with data, then you are using the wrong tool, you be better of with a database.

 

[excelNewbie22]

"The only thing "exactly like Excel" is .... Excel."
accepted.
what does it mean database?
would i see everything like i see it in excel?
is there's a sample? a detail guide?

but most important, would i be able to fill down like in excel?
right now it took me about 4 hours only for a small part of the file

 

[Fluff]

would i see everything like i see it in excel?

Nope.

is there's a sample? a detail guide?

Probably not.

what does it mean database?

A database is a programme (like MS Access) that is designed to work with large amounts of data.

 

[excelNewbie22]

thanks fluff
maybe will try breaking it down to parts

 

[Fluff]

You're welcome.

 

[excelNewbie22]

several more query's i had:
does increasing virtual memory will help?
which component in my hardware is the most importance if i'll decide to upgrade? if it's ram to how much?
does excel would work faster in safe mode? less processes running in bg?
any add-ins that could help?
couple more things i saw in here Handling huge Excel file
excel binary could speed things up? what the disadvantages are?

1. turn calculate off.
2. copy your formulae
3. turn calculate on, or just run calculate manually
4. copy and paste-special-values the formulae outputs.

any thoughts?

 

[Fluff]

any thoughts?

Yes, use a database.

 

[excelNewbie22]

but database won't give the formulas, am i wrong?
and i need to update the file quite a lot

also, none of the above would help? ram??? vm?

 

[Fluff]

also, none of the above would help? ram??? vm?

I have absolutely no idea.

but database won't give the formulas, am i wrong?

Probably depends on what the formulae are.