Openoffice problem in Ubuntu

[Arun Shrimali]

Dear All,

I am working ubuntu 9.04 and OOo3.0.1

While working on vlookup (two different files) I found the final
result with #NAME? error after many combination I could not get the
right output.
Incidentaly, I logout and login as different user, and I found that
vlookup is working perfectly.

I again login as earlier user and do the simple formula like link to
another file (='point to cell in another file') it give the same error
i.e. #NAME?
where as if I use the formula in the same file it works perfectly, if
I use the another file it give the error #NAME? (which is not the case
with the second user)

I concluded that there is some configuration changes made by the user
either in Openoffice or Ubuntu which doesn't make the proper links
between files.
can anybody point me out where could be the problem is ??

Thanks

Arun