Links in Excel workbook not loading due to local google drive location -


i posted in superuser, think may have been wrong place, cross posting here.

-edit: tag google-drive-sdk, it's problem google drive in windows, not api. guess there's no option google drive itself

i have master workbook has links 9 different files. have 2 other workbooks used other people link master workbook information. of these files saved on google drive , associated has access of files individually. until yesterday there wasn't problem loading files, of sudden when opening files on other computers, can't find links , can't load new information.

i'm assuming part of problem due me having google drive saved d:\ drive instead of c:\ of other computers, , in files links point d:\google drive\, said, working until yesterday.

is there way work around issue, without changing drive location? know i'm not person has put google drive on different partition windows, there potential that, causing conflicts.

thank help, , let me know if need more information.

this doesn't drive api - specific inquiry, i'll try pitch in. i'm presuming you're using google drive windows (since indicated google drive installed in d:), location of files referenced inside workbook file absolute. (and others) installed drive app on d:\ wouldn't see problem, others installed on default location may have (which happened when opened files on other computers).

check if can set relative paths instead of absolute paths (same principle can said on drive files), example

d:\google drive\sharedfolder\workbook01.xls d:\google drive\sharedfolder\workbook02.xls d:\google drive\sharedfolder\workbook02.xls

links referencing be

workbook01.xls workbook02.xls workbook03.xls

hopefully location issue.


-

Comments

Post a Comment

Popular posts from this blog

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

angular - Is it possible to get native element for formControl? -

i've got angular2 reactive form . created formcontrol s , assigned input fields by [formcontrol]=... . understand creates nativeelement <-> formcontrol link. my question: possible nativeelement formcontrol ? wanna myformcontrol.nativeelement.focus() i can share 1 terrible solution works me. in reactive forms can use either 1) formcontroldirective ts mycontrol = new formcontrol('') template <input type="text" [formcontrol]="mycontrol"> or 2) formcontrolname ts myform: formgroup; constructor(private fb: formbuilder) {} ngoninit() { this.myform = this.fb.group({ foo: '' }); } template <form [formgroup]="myform"> <input type="text" formcontrolname="foo"> </form> so these directives write patch like 1) formcontroldirective const originformcontrolngonchanges = formcontroldirective.prototype.ngonchanges; formcontroldirective.proto
Read more

javascript - Why jQuery Select box change event is now working? -

i working on product filters user select select box according his/her preference not getting selected value user in jquery. html code:- <select name="product_filter" id="product_filter"> <option value="price_low_first">price : low high</option> <option value="price_high_first">price : high low</option> <option value="latest">latest</option> <option value="popular">most popular</option> </select> jquery code: $(function () { $("#product_filter").change(function () { alert("hi") var selectedtext = $(this).find("option:selected").text(); var selectedvalue = $(this).val(); alert("selected text: " + selectedtext + " value: " + selectedvalue); }); }); hi believe code perfect. once please check jquery.min.js
Read more