Add-in analysis

[gm66]

I am trying to push out a new timesheet to our staff (using Excel 2003 &
2007) and we need to use the MROUND expression. The problem I have is that
our staff in the field do not have easy access to the discs that came with
their laptop so they can install the addin that is required to make the
MROUND work in 2003.

Can anybody identify for me the file on the Office 2003 disc that is the
addin so I can send it out with the timesheet and staff can instal it from
there.

Thanks, g

 

[Mike H]

Hi,

Why don't you use a none ATP formula for MROUND

=MROUND(Number,Multiple)
Becomes
=ROUND(Number/Multiple,0)*Multiple

or a practical example
=MROUND(A1,10)
Becomes
=ROUND(A1/10,0)*10

Mike

 

[Gord Dibben]

The ATP requires more than one file and I believe just adding the files to a
folder will not work................they have to be registered during
installation of Excel.

A typical installation of Office will include installation of the ATP

Are you sure the ATP is not installed?

Is ATP not an option in Tools>Add-ins?

The default location on a regular installation of 2003 is in the folder

C:\Program Files\Microsoft Office\Office11\Library\Analysis

There will be 4 files in the Analysis folder.

ANALYS32.XLL
FUNCRES.XLA
ATPVBAEN.XLA
PROCDB.XLA

If not there then I think you will have to install with CD

You might be able to change your formulas to use a simple ROUND rather than
the MROUND

Post a sample.


Gord Dibben MS Excel MVP

 

[gm66]

Mike,

It worked a treat, thank you very much.

g

 

[gm66]

Gord,

Thanks for your suggestion, I am going to try to pull these out and instal
separately to use other functions.

g

 

[Gord Dibben]

Lotsa luck.

Do you know how to register them?


Gord