Advise Please

[mr moe]

I was asked from managment to automate a spreadsheet either in access or in excel itself or in anyother software. The current spreadsheet takes like 3 hours to be updated, it is so complicated it get links, reference cells and so on, it's also dynamic, meaning the number of rows grows and shrinks. I'm so confused should I try to do it in access or should I tell them that there is no need for automation. I believe that there is not anything I can do since that it's a spreadsheet kind of work. What do you guys think? I"m sorrry I know that I didn't explain the situation clearly but I'm asking for your experience in stuff with spreadsheet that really need to be done only in spreadsheet.

 

[SQL_Hell]

More than one user = Access
More than 50 concurrent users = SQL server
One user = Excel

 

[mr moe]

it's one user but it takes so much time to update the excel file. But at the other hand I don't think that the things they're asking for can be automated because they are dynamic. I guess is that my question, do you believe that almost everything can be automated?

 

[Kodo]

More than one user = Access
More than 50 concurrent users = SQL server
One user = Excel

I agree with the above.

 

[Kodo]

it's one user but it takes so much time to update the excel file. But at the other hand I don't think that the things they're asking for can be automated because they are dynamic. I guess is that my question, do you believe that almost everything can be automated?

Most things can be automated.

 

[Kevin_S]

guess is that my question, do you believe that almost everything can be automated?

why don't you give us an example of one of these complicated. dynamic, automated processes and we'll tell you if a RDMBS is what you want or if keeping the process in a spreadsheet is the best option...

Kev