Thread: Add-in analysis
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gm66 gm66 is offline
external usenet poster
 
Posts: 3
Default Add-in analysis

Gord,

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

g

"Gord Dibben" wrote:

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 ToolsAdd-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



On Sun, 26 Oct 2008 22:32:00 -0700, gm66
wrote:

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