If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
CONVERT Function Disappered in Excel
CONVERT Function is part of the Analysis ToolPak add-in.
ToolsAdd-ins. Check the ATP. Help on CONVERT does state you will need the ATP loaded, BTW. Right up at the top of the page. Gord Dibben Excel MVP On Wed, 13 Apr 2005 00:57:42 +0100, Andy wrote: Hi I have Office XP which I have updated to SP3. I ran Windows Update the other day and it offered to check other programs and it recommended some form of security update for Office which I opted to download. It might be coincidence but I have a worksheet that contains the CONVERT worksheet function which no longer works after this update. When I recalculate, I get #### in the boxes that contain the CONVERT function and when I move the mouse over the box I get #NAME?. If I try the 'Insert Function' option, CONVERT is not available from the list and if I copy & paste a CONVERT example from the help function into a worksheet this fails also. I have uninstalled and reinstalled Office but I still have this problem. Can anyone help? Andy |
#2
|
|||
|
|||
The CONVERT function is part of the Analysis ToolPak add-in. Are you sure you
have this addin insalled - check under ToolsAdd-Ins. Hope this helps Rowan "Andy" wrote: Hi I have Office XP which I have updated to SP3. I ran Windows Update the other day and it offered to check other programs and it recommended some form of security update for Office which I opted to download. It might be coincidence but I have a worksheet that contains the CONVERT worksheet function which no longer works after this update. When I recalculate, I get #### in the boxes that contain the CONVERT function and when I move the mouse over the box I get #NAME?. If I try the 'Insert Function' option, CONVERT is not available from the list and if I copy & paste a CONVERT example from the help function into a worksheet this fails also. I have uninstalled and reinstalled Office but I still have this problem. Can anyone help? Andy |
#3
|
|||
|
|||
Do you have the Analysis Toolpak Add-in installed? You'll need it for the
CONVERT function. Regards, Ron "Andy" wrote: Hi I have Office XP which I have updated to SP3. I ran Windows Update the other day and it offered to check other programs and it recommended some form of security update for Office which I opted to download. It might be coincidence but I have a worksheet that contains the CONVERT worksheet function which no longer works after this update. When I recalculate, I get #### in the boxes that contain the CONVERT function and when I move the mouse over the box I get #NAME?. If I try the 'Insert Function' option, CONVERT is not available from the list and if I copy & paste a CONVERT example from the help function into a worksheet this fails also. I have uninstalled and reinstalled Office but I still have this problem. Can anyone help? Andy |
#4
|
|||
|
|||
Andy
Guess I misunderstood your statement in original post. if I copy & paste a CONVERT example from the help function into a worksheet this fails also. I assumed you had gone to the CONVERT Help. Gord On Wed, 13 Apr 2005 08:01:02 +0100, Andy wrote: On Tue, 12 Apr 2005 17:23:11 -0700, "Ron Coderre" wrote: Do you have the Analysis Toolpak Add-in installed? Thank you all for your replies. This solved has the problem. I did have ATP installed but the online update must have removed it. Yes, I acknowledge that this is in the help but when it's last thing at night and a spreadsheet that has worked with the same software installation on the same computer every week for the past year refuses to run you don't notice these things :-) Thanks again - Andy |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pasting Access table into Excel; can't use SUM function | James Buehner | General Discussion | 3 | November 4th, 2004 11:50 PM |
Add-in functions when starting Excel programmatically | Steve K. | Worksheet Functions | 11 | July 2nd, 2004 06:38 PM |
Convert Excel 97- Excel 2003 | Mike | General Discussion | 1 | June 22nd, 2004 02:07 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |
looking for Excel Function Reference book from 1992? | Matt | Worksheet Functions | 2 | October 29th, 2003 08:04 PM |