Frank Bacchus
Member
Good Morning (appropriate time zone for others):
I have two excel workbook in Sharepoint. Workbook 1 has alot of information and Workbook 2 is pulling information from Workbook 1. I get a couple of messages when I open Workbook 2 (see attachment) about the "spreadsheet having links to other source". One of the messages ask to "Edit Links" - (screen attached).
Looking at the screen presented, there are two entries, (1) an remote connection and (2) a connection to a worksheet on my "C" drive with an error message that the "source cannot be found".
Analysing my spreadsheet, I cannot find any reference to the mentioned excel spreadsheet on my C drive that the error message is referring to. Where is this excel spreadsheet coming from? Where is it being referenced in the spreadsheet 2? Where is the connection message getting this reference from? Please advise.
frank
I have two excel workbook in Sharepoint. Workbook 1 has alot of information and Workbook 2 is pulling information from Workbook 1. I get a couple of messages when I open Workbook 2 (see attachment) about the "spreadsheet having links to other source". One of the messages ask to "Edit Links" - (screen attached).
Looking at the screen presented, there are two entries, (1) an remote connection and (2) a connection to a worksheet on my "C" drive with an error message that the "source cannot be found".
Analysing my spreadsheet, I cannot find any reference to the mentioned excel spreadsheet on my C drive that the error message is referring to. Where is this excel spreadsheet coming from? Where is it being referenced in the spreadsheet 2? Where is the connection message getting this reference from? Please advise.
frank