LinkBack URL
About LinkBacks
I have lots of formulas that reference other spreadsheets but they won't update (even when I hit F9) until I open each spreadsheet that it is referencing. Any Quicker way to do this?
Please Login or Register to view this content.
I have lots of formulas that reference other spreadsheets but they won't update (even when I hit F9) until I open each spreadsheet that it is referencing. Any Quicker way to do this?
Please Login or Register to view this content.
Hi jiptastic,
One way would be having full path of the workbooks in the formulas starting from the server name. Also check if your workbook's calculation mode is set to automatic. Thanks.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
VLookup won't work if your sheet isn't open.
Dear forummembers:
The above line (statement) is incorrect.
It also works in closed workbooks (I tested it afterwards).
I'm sorry for posting wrong information.
Last edited by oeldere; 01-26-2013 at 05:35 AM.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Dear oeldere, Vlookup fetches values even from closed workbook. I have just checked this, to be sure of, before writing this post.VLookup won't work if your sheet isn't open.
Regards,
DILIPandey
<click on below * if this helps>
@dilipandey
Thanks for pointing me on the incorrect statement
I changed my post in #3 so everybody can learn of it.
Thanks again for the reply.
Now i see post #3 is deleted so nobody can learn of my faillure
Last edited by oeldere; 01-26-2013 at 05:45 AM.
you are welcome my friend... suggest you to report that post#3 so that any available MOD can remove that. Thanks.
Regards,
DILIPandey
<click on below * if this helps>
@Dilipandey
And now #3 is back in the treat !! => some magic is around this
I don't mind post #3 is there, people can learn from it.
I'll start using the full path names in these. Thanks.
You are welcome Jiptastic..
Cheers
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks