Automatically save data locally (not referencing a server) when closing the file

Hello-


A partner emails me a workbook (comprising of several worksheets) every day but they populated one worksheet with data from a server location at their company location (no idea why.)

When I open the file at my company the data (numbers) is missing since on this one worksheet since I do not have (or want) access to their server location.

Is there some magical way when they save their file it simply saves their data in the worksheet rather than reference the server location? I’d like to be able to instruct my partner on how this can be done.

Best regards-

j

Had a hunch would hear something like that. Maybe I’ll just ask them to not reference the server.

Always a pleasure Ron-

j

Hi there, but don't You get a pop up window asking whether to continue or check the links and that the source cannot be found? I assume You disregard it (choose continue) and You get displayed all the numbers visual (with underlying links).To get rid of the links, which You can do Yourself or You can ask the liaison person, and to supplement advice from Ron to perform drop (all) the links, ie. for (excel 2007) from Data menu> Connections tab> Edit links. There One can break the link for all the links in the workbook. On the other hand I am quite sure the person has good reason to reference the server for data.

Regards

I was able to get the partner to cease linking the 'foreign' server - thanks all.

jt