New Computer HPVAL no longer works

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

macgron - 12 Feb 2007 16:15 GMT

I have just had my computer updated. A spreadsheet that I regularily use, but
i supplied to me by other people not longer works. The probelsm seem to be
coming from 2 function2 HPVAL & HPLNK. Examples of their useage are:
=HPLNK(-'EARC Input'!C39*1000,$A7,D$1,D$4,D$2,D$3,D$5)
=-HPVAL($A40,E$1,E$3,$C$2,E$2)/1000

These are not standard functions as per my email

Reply to this Message

Bernard Liengme - 12 Feb 2007 16:55 GMT

I expect you had an addin running on you old computer.
The addin would have contained the functions
Hope the old PC is still available
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>I have just had my computer updated. A spreadsheet that I regularily use,
>but
[quoted text clipped - 5 lines]
>
> These are not standard functions as per my email

Reply to this Message

Dave F - 12 Feb 2007 16:58 GMT

If they're not standard functions then post the VBA code used to create them.
Else no one can diagnose the problem for you.

Also make sure your macros are running.

Dave

Signature

A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

> I have just had my computer updated. A spreadsheet that I regularily use, but
> i supplied to me by other people not longer works. The probelsm seem to be
[quoted text clipped - 3 lines]
>
> These are not standard functions as per my email

Reply to this Message

David Biddulph - 12 Feb 2007 17:52 GMT

A quick Google will point you at the software package which probably
introduces those additional functions. Do you have that software on your
new machine?

Signature

David Biddulph

>I have just had my computer updated. A spreadsheet that I regularily use,
>but
[quoted text clipped - 5 lines]
>
> These are not standard functions as per my email

Reply to this Message