excel and access file size

[WH0ELSE]

hi there
can anyone please tell me what is, if there is at all, maximum size of excel and access files?????
i have one file that is 217MB in size and it seams that it cant take any more information in!!! is that due to this file size or is it something else??
thanx for any response!!!!!!!!!!!

WH0ELSE
I think therefore i am.....

 

[WH0ELSE]

i am using office xp pro. and the file is access file database!!

WH0ELSE
I think therefore i am.....

 

[xlbo]

there is no max "size" of an excel workbook - there are however memory limitations and it will start running like a proverbial dog if it gets bigger than ~50meg. The main thing that prohibits excel files from working well is the number of calculations in the workbook - excel can only hold 65536 dependancies in its calculation tree - once passed this and it has to recalc everything every time a change is made. For Access, there is no max database size but there are memory limits for individual tables - apprx 1 gig pre XP and 2 gig for XP. This is not to do with the number of rows but more to do with the number of fields and the field types (ie memo fields take up a LOT more memory than integer fields)

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244