Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ATPBAEN.XLA Link created when using XIRR
I am having a bizarre problem in Excel 2003. When create a spreadsheet on my
desktop, I can use the XIRR function. However, when I open a spreadsheet created on another desktop which has an XIRR, something weird happens. When I open the file everything is fine. However, when I click onto the cell with the XIRR function, click into the formula bar and then escape out of the formula, I get the #NAME? Error. And when check Edit/Links it appears as though I have a new link to the ATPBAEN.XLA. Now I know that the XIRR is a part of the ATPBAEN.XLA. It seems as though I lose access to the function once I click into th formula box. Why is this? EM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link cells to documents that aren't created yet | Excel Discussion (Misc queries) | |||
xirr | Excel Worksheet Functions | |||
Xirr? | Excel Discussion (Misc queries) | |||
link to not-yet-created workbook | Excel Discussion (Misc queries) | |||
my link menu is unavailable... I have created links and now the l. | Excel Worksheet Functions |