Most probably we will be going to implement a database
solution. Since we cannot design our own Access database
(central company IT regulations forbid workers to design
own databases since without central knowlegde/control no
support can be given in case of problems), we will have
the IT department to design (probably with Discovery DB)
our new application.
Any suggestions as how to go along with the design?
- What aspects of database are important;
- What costs could be involved for a 10 persons access (I
ask since we never have had such a project).
TIA again for suggestions!
Martin
-----Original Message-----
Without seeing the whole thing I can only make some
general comments.
As i see it you have two choices: spend your time
transferring this
application to a database, or spend your time nursing
this ailing
application along.
A bigger box might work in the short term, but if you are
adding data and
functionality you will, probably, soon be back in the
position you are in
today.
Complicated formulas? Databases work in a different way -
you might not need
complicated formulas (databases are usually very strong
on reporting).
Or, keep your data in a database and extract subsets of
data you want to
manipulate to Excel.
HTH
--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
"Martin Los" wrote
in message
...
At work we analyze salesdate of several departments for
years 2002, 2003 and 2004. In total I have a worksheet of
30 MB (!), 10 worksheets (some of which have 20.000
lines).
From the worksheets we get the date using vlookup and
sum.if functions to get a summary report with comboboxes,
allowing the user to select summary of days or months.
Due to enormous amount of functions to calculate, the
worksheet isnīt practical anymore; it takes ages ( 10
seconds) for each query of the combobox to be executed. On
my P-III 600Mhz (with 256 Mhz internal memory) with
Windows and Office XP I canīt even get workbooks opened
anymore!
I am looking for a solution:
1. Get a more powerful computer
(Disadvantage: my collegeaus with P-IV 2,4 Ghz and 256 Mhz
have same problems - so this solution does not seem
adecuate)
2. Get data into a real database.
(Disadvantage: the formulaīs used canīt be exported
easily)
Does anybody have suggestions as how to get our workbooks
manageable?
TIA
Martin
.