excel - Formula information displaying correctly, but link information is not -


path error

close up

in picture above have placed following formula in cell j1:

=hyperlink(left(cell("filename",a1),find("[",cell("filename",a1))-1),left(cell("filename",a1),find("[",cell("filename",a1))-1))

i created file on local c: drive , personal download folder. created hyper link formulas in i4, , copied down, build on path name j1. worked fine , dandy when tested it.

problem

when move file network drive, value in cell j1 showed new new network path. when click on link open personal download folder created , saved workbook.

what have tried

i thought there might value saved not updated when moved file since used explorer move file opposed saving open workbook in new location. on come tried saving file in new location no effect. tried save no effect either.

what trying achieve

i trying achieve automatic link allow user click on drawing link , open associated file independent of how have mapped or reference network location. automatically update path should folder moved or renamed.

what went wrong? there better way of doing this?

potential cause

when using =hyperlink formula, excel generates hyperlink if added 1 manually right clicking on cell. formats text underline , blue/purple text. "manually" created hyperlink sits on top of formula gets selected first. "manual" hyperlink not update.

work around

select cells issue. right click bring menu , select remove hyperlink. removes excels "manual" hyperlink, leaves cells hyperlink formula still works , updated.


Comments

Post a Comment

Popular posts from this blog

PHP and MySQL WP -

i trying accomplish 2 things here code. writing php directly wp page using insert php plugin. 1) query mysql database , return results 1 column 4 columns. 2) make each result own hyperlink directs user new wp page runs new query on page. i able query show results , turn results dynamic hyperlink, cannot formatting down. right returns result 1 column. here have: [insert_php] $servername = "localhost"; $username = "login"; //edited privacy $password = "password"; //edited privacy $database = "database"; //edited privacy // create connection $conn = new mysqli($servername, $username, $password, $database); // check connection if ($conn->connect_error) { die("connection failed: " . $conn->connect_error); } echo "connected successfully"; //get results database $result = mysqli_query($conn,"select mine mines order mine"); $all_property = array(); //declare array saving property //showing proper...
Read more

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

go - golang pprof for c library code -

i have been trying profile golang application pprof, seems details of c code(linked static library) missed in output result. flame graph from frame graph can see c code time consuming reported within "runtime._externalcode", no details @ all. , sure static library compiled debug enable. so there way make pprof details(like stack trace) of 3rd party c code? or there other golang profiling tool this?
Read more