Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add-in analysis
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add-in analysis
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 "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add-in analysis
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add-in analysis
Mike,
It worked a treat, thank you very much. g "Mike H" wrote: 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 "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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add-in analysis
Lotsa luck.
Do you know how to register them? Gord On Mon, 27 Oct 2008 15:19:01 -0700, gm66 wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
analysis | Excel Worksheet Functions | |||
Analysis | Excel Worksheet Functions | |||
Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |