eekfonky23
Power User
Joined: 18 May 2007
Posts: 55
Location: Scotland
|
 Posted: Sat Jun 13, 2009 7:44 pm Post subject: Custom functions cell reference across workbooks |
 |
|
I have created simple custom functions to deal with British VAT, French TVA and British duty. I have links across several workbooks. When I have the functions in My Macros this works fine. However, when I place the functions into specific workbooks and reference the cell across to another, I get #VALUE!. Even if I place the same customs fucntions into the workbook where the cell is referenced to.
i.e
| Code: | | ='file:///home/me/Activity/InProg/Embedded_Functions/1_Rates.ods'#$CDV.K5 |
in a separate workbook references to a cell with a custom function and returns
I have a workaround but it's temporary as VAT, TVA and duty change I cannot have them in 'My Macros' as all previous workbooks will change with the new rates.
Is this problem addressed in newer versions of OO. I am using ubuntu 9.04 with the built-in OO.
Any ideas |
|
