New Computer HPVAL no longer works

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking up whether one item has a certain matching item 6
sums with several conditions 1
SUMIF to sum multiple columns of data? 2
Use cell contents to refer to a sheetname in a formula 6
What do you use your R-Pi for - which Projects are you planning!? 1
Can you help to find the right formula? 4
Stock control question 4
Count number of indirect connections between airports 0

Back
Top