Linked Cells Returning #REF! Across Networks Workbooks

[JohnSlider]

Hello All!

I currently have a master data workbook hosted on my network, and I would like to extract information from that workbook to populate another workbook.

I thought this would be simple, because I am currently extracting key information from this master file to populate a few PowerPoint documents. However, when I try to link cells in another workbook I end up with the following:

Any idea what I'm doing wrong? The data appears fine when I first paste the link, but the above occurs when I try to open the document from the server and update the links.

 

[starl]

Your formula is R1C1, but your workbook is configured A1..
The formula itself is strange to me (the beginning part i've never seen), but on the right you have many ! and extra quotes...

Here is an example of a link:
='[Book1]Two Words'!$A$1

Note that the quotes go around the workbook and sheet name and there is one ! after the sheet name, outside of the single quotes.

Are you on a sharepoint server?

 

[JohnSlider]

I am (unfortunately!).

Sorry, did not realize that was relevant.

 

[starl]

I'm not familiar with Sharepoint (just the headaches and to avoid it *lol*), but here's a post that discussed linking between files on a sharepoint server. One thing that i found interesting - both must be open when doing updates... doesn't seem very practical to me.

https://social.technet.microsoft.co...-in-a-sharepoint-2010-environment?forum=excel

 

[JohnSlider]

Oh wow, yeah, that won't work. End users for each spreadsheet are different so this just isn't practical. Thank you for the insight.

 

[starl]

Seems silly that there isn't a workaround for SharePoint setups.. it's still just a network. Are you accessing the files via the sharepoint directory or directly?

honestly, i'm rather over my head with this.. but i've had clients who used sharepoint servers and didn't report such problems. But then - they didn't use sharepoint the way it was meant..