Variable Sharepoint link into Excel Closed

Question

Hello, 



Configuration: Windows XP / Internet Explorer 7.0

Looking to allow a cell value to dictate a link to a spreadsheet in Sharepoint.  So if Cell A1 is "Corporate", then, I need a link in cell B2 to get data from the relevant spreadsheet in Sharepoint, so something like ='//teamsite.company.com/"&A1&".xlsx[Sheet1]!F4"
Now of course the above doesn't work....   Help!!

Ambucias · Answer

Greetings, 

Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems.  They do have a life other than this forum including me.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum. 
https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse 

To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help! 

You must copy, modify and repost your message respecting the politeness charter.

We trust that you understand. 

Moderator

Variable Sharepoint link into Excel

1 response

Similar discussions

Subscribe To Our Newsletter!