Is Excel enough power for 80.000 cells? Should I use Access to?

Hello, I have to do an application to handle 14 columns (date and 13 integer variables) and rows to cover day by day through 15 years. That is 14*365*15 cells.

I must do searches and comparisons between cells, and some mathematical calculations (those ones won't be through all cells, but just between some 10 or 20 selected cells).

The question is, should I use Access too to handle this information, or is Excel enough powerfull to work with that alone? I prefer working with Excel alone, but if it is needed, then the application will be made based on both.

You should use a database for sure.
Access, Microsoft SQL server, MYSQL, Oracle or another one.
having that amount of data especcialy to search is database stuff.

Spreadsheets are for calculating not for storing data.

Baldomero,

You'll need less than 6000 rows to accomplish this. Not a problem with
Excel. The choice has little to do with capacity, but more with what you
want to do. For calculations, Excel excels. For storing in tables,
especially multiple tables (which you don't seem to need), handling records,
input forms, output screens and printed reports, Access is better. So on
the surface, anyway, with what you've said about what you need to
accomplish, Excel is the choice.
--
Earl Kiosterud
www.smokeylake

"baldomero" <baldomero.1tyz6a_1124384706.0622@excelforum-nospam.com> wrote
in message news:baldomero.1tyz6a_1124384706.0622@excelforum-nospam.com...
>
> Hello, I have to do an application to handle 14 columns (date and 13
> integer variables) and rows to cover day by day through 15 years. That
> is 14*365*15 cells.
>
> I must do searches and comparisons between cells, and some mathematical
> calculations (those ones won't be through all cells, but just between
> some 10 or 20 selected cells).
>
> The question is, should I use Access too to handle this information, or
> is Excel enough powerfull to work with that alone? I prefer working with
> Excel alone, but if it is needed, then the application will be made
> based on both.
>
>
> --
> baldomero
> ------------------------------------------------------------------------
> baldomero's Profile:
> http://www.excelforum.com/member.php...o&userid=25680
> View this thread: http://www.excelforum.com/showthread...hreadid=396898
>

Well, then I'll try with Excel alone. I'll comment on that when I implement the application to you guys. Thanks!!

**** excel in the mouth.

use access.