Joined: 18 May 2007
|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.
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.