Access 2007 or Excel 2007

K

Kelsey

Hi all. I am currently using Excel 2003 for a big project-- mainly, a large
spreadsheet that holds the names, addresses, and other information for
thousands of clients. However, I need to have multiple people working on this
file, sometimes simultaneously, and have therefore outgrown the 2003 edition.

My question is which of these would be better to update to? I know that
Excel 2007 purportedly has new functions that allow it to behave more like a
database than past versions, however I'm concerned about limitations on the
number of users.

Can anyone provide me insight on this dilemma. Thanks!
 
B

Bob I

Kelsey said:
Hi all. I am currently using Excel 2003 for a big project-- mainly, a large
spreadsheet that holds the names, addresses, and other information for
thousands of clients. However, I need to have multiple people working on this
file, sometimes simultaneously, and have therefore outgrown the 2003 edition.

My question is which of these would be better to update to? I know that
Excel 2007 purportedly has new functions that allow it to behave more like a
database than past versions, however I'm concerned about limitations on the
number of users.

Can anyone provide me insight on this dilemma. Thanks!
Click to expand...

The larger size handled by Excel will be even slower. Just because you
can plug in more data in a spreadsheet, doesn't make Excel a database
engine.
 
B

Beth Melton

Kelsey said:
Hi all. I am currently using Excel 2003 for a big project-- mainly, a
large
spreadsheet that holds the names, addresses, and other information for
thousands of clients. However, I need to have multiple people working on
this
file, sometimes simultaneously, and have therefore outgrown the 2003
edition.

My question is which of these would be better to update to? I know that
Excel 2007 purportedly has new functions that allow it to behave more like
a
database than past versions, however I'm concerned about limitations on
the
number of users.

Can anyone provide me insight on this dilemma. Thanks!
Click to expand...

If you are working with thousands of records and multiple people need to
access the data at the same time then you need to use Access and not Excel.
Upgrading to Office 2007 won't resolve this. It would be similar to going
from using a dress shoe to hammer a nail and then trying a work boot hoping
it will hammer the nail faster. Sure it will work a little better but it's
still difficult. All you need to do is use the right tool for the job. :)

--
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx
 
Top